Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1220: "alter table rename to" inside a transaction violates ACID ordering - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1220: "alter table rename to" inside a transaction violates ACID ordering
Date
Msg-id 4554.1092755398@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1220: "alter table rename to" inside a transaction violates ACID ordering  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Responses Re: BUG #1220: "alter table rename to" inside a transaction  (Adam Sah <asah@speakeasy.net>)
List pgsql-bugs
Tree view 
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> ==> yikes!  in window 2, it should have errored.

Why are you of the opinion that this is a bug?  The catalog lookup has
to happen before the second xact can hope to obtain a lock on the table,
no?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1220: "alter table rename to" inside a transaction violates ACID ordering
Next
From: Tom Lane
Date:
Subject: Re: BUG #1220: "alter table rename to" inside a transaction violates ACID ordering