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

Gregory Stark escribió:
>
> <megous(at)gmail(dot)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