2 gig limitation?

i've noticed that one of our databases looks a bit strange:

-rw-------  1 pgsql  pgsql  2147483648 Apr 28 23:06 gt
-rw-------  1 pgsql  pgsql   171073536 Apr 29 08:28 gt.1

is there some strange thing that happens when a database exceeds 2 gig in size?

i have a nightly process which selects the previous 30 days data into a
new table, then does a:
alter table rename gt to gt_old;
alter table rename gt_new to gt;
create unique index gt_index on some_field;

the create index failed.

--
[ Jim Mercer    Reptilian Research      jim@reptiles.org   +1 416 410-5633 ]
[ The telephone, for those of you who  have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail.            ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]