From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | gabrielle <gorthx(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Mark Wong <markwkm(at)gmail(dot)com>, David Christensen <david(at)endpoint(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Explicit psqlrc |
Date: | 2010-06-22 08:34:38 |
Message-ID: | 1277195678.32273.4922.camel@ebony |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 2010-06-21 at 20:53 -0400, Robert Haas wrote:
> On Mon, Jun 21, 2010 at 7:51 PM, gabrielle <gorthx(at)gmail(dot)com> wrote:
> > On Thu, 2010-06-17 at 14:50 -0400, Alvaro Herrera asked:
> >> How does it play with ON_ERROR_STOP/ROLLBACK?
> >
> > With ON_ERROR_STOP=ON, psql issues an error when it encounters one,
> > stops processing the file that contains the error, and then continues
> > to process any remaining files.
That would be undesirable.
> > I'm still investigating ON_ERROR_ROLLBACK. I need to tinker with it
> > some more before I say anything concrete.
> >
> > On Fri, Jun 18, 2010 at 1:48 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> >> Also, how does it play with --single-transaction.
> > That was buried in our original report :) "BEGIN-COMMIT statements
> > within the files cause warnings when the command is wrapped in a
> > transaction with the -1 switch (as specified in the patch submission)"
> >
> > To expand upon that a bit: when psql encounters a file that contains
> > a BEGIN statement, you get the expected "WARNING: there is already a
> > transaction in progress" message. The COMMIT at the end of that file
> > (assuming the user doesn't forget it) generates a COMMIT. Commands
> > after that commit, or in any remaining files to be processed, are
> > dealt with according to the user's autocommit settings:
> > - if autocommit is ON, statements in the remaining files are processed
> > & committed; the implicit COMMIT at the end of the whole thing then
> > generates a "WARNING: there is no transaction in progress" message
> > - if autocommit is OFF, statements in the remaining files generate
> > "ERROR: current transaction is aborted, commands ignored until end of
> > transaction block" messages.
This is the existing behaviour.
> So none of the above sounds like desired behavior to me... is that just me?
Single transaction needs some help, but that's not the fault of this
patch.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2010-06-22 09:41:30 | Re: system views for walsender activity |
Previous Message | Guillaume Lelarge | 2010-06-22 07:54:16 | Re: system views for walsender activity |