Re: [HACKERS] autocommit vs TRUNCATE et al

[Joe Conway]

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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster