Skip site navigation (1) Skip section navigation (2)

Re: --single-transaction doc clarification

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgresql(dot)org, Neil Conway <neilc(at)samurai(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: --single-transaction doc clarification
Date: 2006-10-31 02:31:28
Message-ID: 22553.1162261888@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Neil Conway <neilc(at)samurai(dot)com> writes:
> On Tue, 2006-10-31 at 01:07 +0000, Simon Riggs wrote:
>> As requested.

> Applied, thanks for the patch.

This patch converted a correct statement into a lie: there is not
anything that will cause begin/commit in a script file to fail just
because you wrapped begin/commit around them.  I rewrote the text to

        If the script itself uses <command>BEGIN</>, <command>COMMIT</>,
        or <command>ROLLBACK</>, this option will not have the desired
        effects.
        Also, if the script contains any command that cannot be executed
        inside a transaction block, specifying this option will cause that
        command (and hence the whole transaction) to fail.
 
			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-10-31 03:23:30
Subject: Re: Case Preservation disregarding case sensitivity?
Previous:From: Neil ConwayDate: 2006-10-31 01:52:56
Subject: Re: --single-transaction doc clarification

pgsql-patches by date

Next:From: Thomas H.Date: 2006-10-31 06:23:37
Subject: Re: xlog lockup patch (was: BUG #2712: could not fsync segment: Permission)
Previous:From: Neil ConwayDate: 2006-10-31 01:52:56
Subject: Re: --single-transaction doc clarification

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group