[BUGS] ALTER TABLE table RENAME TO sould change also sequence name

2003-08-14 Thread Mirek Hankus
Postgresql 7.3.4 on Linux. Problem is that when you create a table with serial type, it creates sequence with coresponding name. Then you can grant some rights to it (table and sequence), and after that change table name. From now on you will not be able to restore such database, because name of s

Re: [BUGS] ALTER TABLE table RENAME TO sould change also sequence name

2003-08-12 Thread Bruce Momjian
TODO has: o Have ALTER TABLE rename SERIAL sequences However, I didn't realize the seriousness of the problem. --- Mirek Hankus wrote: > > Postgresql 7.3.4 on Linux. > > Problem is that when you create a table wi