Re: 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!