Re: [HACKERS] DROP TABLE inside transaction block

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] DROP TABLE inside transaction block
Дата
Msg-id 3242.938612032@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] DROP TABLE inside transaction block  (Mike Mascari <mascarim@yahoo.com>)
Список pgsql-hackers
Mike Mascari <mascarim@yahoo.com> writes:
> If my TRUNCATE TABLE patch was applied as submitted,
> (I haven't downloaded a newer snapshot yet), then
> it falls into category #2...same as VACUUM. It 
> commits the current transaction before truncating
> the specified relation, then begins a new transaction.

I took all that out ;-) while updating it to compile against the current
state of heap_open et al.  I see no need for multiple transactions in
TRUNCATE.  It's really on a par with RENAME TABLE, since both have to
force a buffer flush.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] DROP TABLE inside transaction block
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: RI and PARSER (was: Re: [HACKERS] RI status report #1)