Hi Sumbry][,

> [..] It looks like even with
> the table prefixes, if you ran a pre RC8 version then you'll have table
> names with prefixes, but index names, sequences, etc with the old style
> of naming.  And of course in Postgres, there is no RENAME INDEX or
> RENAME SEQUENCE command.

Of course there is - hidden but it's there:

alter table oldindex rename to newindex;
alter table oldsequence rename to newsequence;

I still have to migrate to tablenames with prefixes, I'll post the
script when it's done.


Thomas
-- 
http://www.tmueller.com for pgp key (95702B3B)

Reply via email to