Saturday, August 9, 2008

Re: [BUGS] ALTER TABLE name RENAME TO new_name; does not work immediately

<megous@gmail.com> writes:

> Here is a script that is able to reproduce the problem (on my machine
> anyway), you may need to play with the number of rows or workmem
> settings to be able to reproduce it:

Egads, i can confirm that this script reproduces the problem on my machine as
well:

ALTER TABLE xxx RENAME TO yyy;
ALTER TABLE
ALTER TABLE yyy RENAME COLUMN col1 TO colA;
ERROR: relation "yyy" does not exist

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

No comments: