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

Поиск
Список
Период
Сортировка
От Adam Sah
Тема Re: BUG #1220: "alter table rename to" inside a transaction
Дата
Msg-id 412220D0.7010209@speakeasy.net
обсуждение исходный текст
Ответ на Re: BUG #1220: "alter table rename to" inside a transaction violates ACID ordering  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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:

> "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 по дате отправления:

Предыдущее
От: Stefanos Harhalakis
Дата:
Сообщение: pgsql 8.0.0b1 - openssl detection
Следующее
От: "Ken Egervari"
Дата:
Сообщение: I/O Bug