Re: autocommit vs TRUNCATE et al - Mailing list pgsql-hackers

From Joe Conway
Subject Re: autocommit vs TRUNCATE et al
Date
Msg-id 3DB0B94E.4030903@joeconway.com
Whole thread Raw
In response to Re: autocommit vs TRUNCATE et al  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: autocommit vs TRUNCATE et al
Next
From: Gavin Sherry
Date:
Subject: Re: autocommit vs TRUNCATE et al