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

Gregory Stark escribió:
>
> <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

On what version?  Sounds like a problem in sinval message processing.

I could not reproduce it here, but didn't try very hard.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support