Re: autocommit vs TRUNCATE et al

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: autocommit vs TRUNCATE et al
Дата
Msg-id 3DB0B94E.4030903@joeconway.com
обсуждение исходный текст
Ответ на Re: autocommit vs TRUNCATE et al  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian wrote:
> Joe Conway wrote:
> 
>>Bruce Momjian wrote:
>>
>>>>most useful approach.  The analogy to SET hadn't occurred to me.
>>>
>>>
>>>Yea, the SET behavior appeared pretty queer to me, but now that I have
>>>used it, I am getting used to it.

<snip examples>

> 
> In the last case, the TRUNCATE will happen, and the INSERTs will be in
> their own multi-statement transaction.  A SET in place of TRUNCATE will
> behave the same way.
> 

Hmmm. It does look strange. We ought to make this prominent in the release 
notes and docs.

Joe



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: autocommit vs TRUNCATE et al
Следующее
От: Gavin Sherry
Дата:
Сообщение: Re: autocommit vs TRUNCATE et al