Re: Limit for an transaction

From: Charles Tassell <ctassell(at)isn(dot)net>
To: Matthias Teege <matthias(at)mteege(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: Limit for an transaction
Date: 2000-06-27 02:27:59
Message-ID: 4.3.2.7.2.20000626232635.00d28510@mailer.isn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

No, there is no limit to the number of statements in a transaction. You
get that error when you try to issue another statement in a transaction
after the previous statement has failed. You have to rollback the
transaction in order to continue after one of the statements fails, else
you get that error.

At 02:37 PM 6/26/00, Matthias Teege wrote:

>Moin,
>
>ist there any limit for the length of an transaction? I'am
>using postgreSQL 6.5.1 with PHP and the apache log says:
>
>NOTICE: (transaction aborted): queries ignored until END
>
>Many thanks
>Matthias

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mitch Vincent 2000-06-27 04:23:04 Linux/Postgre question.
Previous Message Thomas Lockhart 2000-06-27 02:07:54 Re: Inserting all defaults