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

2008-08-11 Thread megous
On 9 Srp, 19:38, [EMAIL PROTECTED] (Gregory Stark) wrote: > <[EMAIL PROTECTED]> writes: > > ALTER TABLE name RENAME TO new_name; > > ALTER TABLE new_name > >   RENAME COLUMN x TO y; > > ... > > I think the issue might be reproducible by creating table with a lot > > of rows, setting high work_mem a

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

2008-08-09 Thread Alvaro Herrera
Gregory Stark escribió: > > <[EMAIL PROTECTED]> 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 t

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

2008-08-09 Thread Gregory Stark
<[EMAIL PROTECTED]> 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

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

2008-08-09 Thread megous
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: regards, Ondrej Jirman #!/bin/sh dropdb bug createdb bug psql bug << EOF CREATE TABLE xxx (id SERIAL, col1 TEXT, col2

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

2008-08-09 Thread Gregory Stark
<[EMAIL PROTECTED]> writes: > ALTER TABLE name RENAME TO new_name; > ALTER TABLE new_name > RENAME COLUMN x TO y; > ... > I think the issue might be reproducible by creating table with a lot > of rows, setting high work_mem and issuing the commands, but I did not > try to reproduce it this way.

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

2008-08-09 Thread megous
Oh, I've forgot to mention that the commands are issued from the script. When issued by hand there is no problem at all (probably because I'm a slow typist :-D). Thank you and regards, Ondrej Jirman -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subs