From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Luiz Rafael Culik Guimaraes <culikr@brturbo.com>
Cc: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: number os commands inside transaction block
Date: Mon, 31 Jan 2005 16:49:15 -0600
Message-ID: <1107211755.16640.157.camel@state.g2switchworks.com> (raw)
In-Reply-To: <045701c507e4$5c1c1790$0105a8c0@luiz>
References: <6c21003b0501301141234c256b@mail.gmail.com>
<20050131132701.G12960@megazone.bigpanda.com>
<043f01c507df$9174a790$0105a8c0@luiz>
<20050131221306.GA51538@winnie.fuhr.org>
<045701c507e4$5c1c1790$0105a8c0@luiz>
On Mon, 2005-01-31 at 16:29, Luiz Rafael Culik Guimaraes wrote:
> Hi Michael Fuhr
> >> how i can increse the number of commands in an transaction block
> >
> > What do you mean? What problem are you trying to solve?
>
> i´m trying to solve the follow message
> current transaction is aborted, queries ignored until end of transaction
> block
>
> some one tell me this is defined inside postgres sources
> i recive this message when i execute an certain number of queries inside an
> begin/commit block
This is normal postgresql behaviour, and can't really be changed.
However, with the advent of savepoints in 8.0, it is now possible to
detect such errors and roll back so you can then continue. Without
using savepoints with rollback to the given save point, however, there's
not much way to get around it.
It sounds to me like you're getting an error somewhere in your scripts
you need to look into.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: smarlowe@g2switchworks.com, culikr@brturbo.com, mike@fuhr.org
Subject: Re: number os commands inside transaction block
In-Reply-To: <1107211755.16640.157.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox