Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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:

>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

In response to

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group