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

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: <megous(at)gmail(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: ALTER TABLE name RENAME TO new_name; does not work immediately
Date: 2008-08-10 00:50:33
Message-ID: 873aldelra.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


<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

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2008-08-10 01:58:17 Re: ALTER TABLE name RENAME TO new_name; does not work immediately
Previous Message Richard Evans 2008-08-09 19:46:02 Re: BUG #3818: Cross compilation problems