Re: Limit for an transaction - Mailing list pgsql-general

From Charles Tassell
Subject Re: Limit for an transaction
Date
Msg-id 4.3.2.7.2.20000626232635.00d28510@mailer.isn.net
Whole thread Raw
In response to Limit for an transaction  (Matthias Teege <matthias@mteege.de>)
List 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


pgsql-general by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Inserting all defaults
Next
From: "Mitch Vincent"
Date:
Subject: Linux/Postgre question.