Re: [HACKERS] [BUGS] BUG #1883: Renaming a schema leaves inconsistent

2005-09-27 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > With the following errors caused by ALTER SCHEMA RENAME, I recommend we > > remove this feature for 8.1 and revisit it for 8.2. > > It's a mistake to blame ALTER SCHEMA RENAME for this problem, as you can > cause it equally well by renaming the sequence

Re: [HACKERS] [BUGS] BUG #1883: Renaming a schema leaves inconsistent

2005-09-27 Thread Tom Lane
Bruce Momjian writes: > With the following errors caused by ALTER SCHEMA RENAME, I recommend we > remove this feature for 8.1 and revisit it for 8.2. It's a mistake to blame ALTER SCHEMA RENAME for this problem, as you can cause it equally well by renaming the sequence itself, or by moving it int

Re: [HACKERS] [BUGS] BUG #1883: Renaming a schema leaves inconsistent

2005-09-27 Thread Bruce Momjian
With the following errors caused by ALTER SCHEMA RENAME, I recommend we remove this feature for 8.1 and revisit it for 8.2. I would just remove the grammar construct for it and the documentation. To fix this, we would need to redesign the way we store DEFAULT sequence assignments, and I don't th

Re: [HACKERS] [BUGS] BUG #1883: Renaming a schema leaves inconsistent sequence

2005-09-22 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > This item has been added to the 8.1 bugs list: > > http://momjian.postgresql.org/cgi-bin/pgbugs > > This isn't going to be fixed for 8.1. I think it's really a variant of > the TODO item > o %Have ALTER TABLE RENAME rename SERIAL sequence nam