Re: [BUGS] BUG #1220: "alter table rename to" inside a transaction

#1

well, that's fine I suppose -- but then why does it work the other way
for DROP TABLE?

i.e. feels like we're confusing "implementation" and "desired semantics"

adam

Tom Lane wrote:

Quote:

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #1220: "alter table rename to" inside a transaction

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #1220: "alter table rename to" inside a transaction - 08-18-2004 , 10:58 AM