| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-10-31 03:23:30 | Re: Case Preservation disregarding case sensitivity? |
| Previous Message | Neil Conway | 2006-10-31 01:52:56 | Re: --single-transaction doc clarification |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas H. | 2006-10-31 06:23:37 | Re: xlog lockup patch (was: BUG #2712: could not fsync segment: Permission) |
| Previous Message | Neil Conway | 2006-10-31 01:52:56 | Re: --single-transaction doc clarification |