Re: ALTER TABLE name RENAME TO new_name; does not work immediately - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: ALTER TABLE name RENAME TO new_name; does not work immediately
Date
Msg-id 20080810015817.GA3759@alvh.no-ip.org
Whole thread Raw
In response to Re: ALTER TABLE name RENAME TO new_name; does not work immediately  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: ALTER TABLE name RENAME TO new_name; does not workimmediately
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Gregory Stark
Date:
Subject: Re: ALTER TABLE name RENAME TO new_name; does not work immediately
Next
From: Gregory Stark
Date:
Subject: Re: ALTER TABLE name RENAME TO new_name; does not workimmediately