Thread

1. Limit for an transaction

   Matthias Teege <matthias@mteege.de> — 2000-06-26T17:37:52Z

   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
   
   

2. Re: Limit for an transaction

   John Huttley <john@mwk.co.nz> — 2000-06-26T19:08:36Z

   I've had this also. The problem has always been that I've made a mistake in my
   SQL.
   
   Since the transaction is going to rollback anyway, any subsequent changes are
   ignored.
   I've done 95,000 inserts in a transaction without problems.
   
   Regards
   
   John
   ----- Original Message -----
   From: Matthias Teege <matthias@mteege.de>
   To: <pgsql-general@postgresql.org>
   Sent: Tuesday, 27 June 2000 05:37
   Subject: [GENERAL] Limit for an transaction
   
   
   >
   > 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
   >
   
   
   
   

3. Re: Limit for an transaction

   Charles Tassell <ctassell@isn.net> — 2000-06-27T02:27:59Z

   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
   
   
   

4. Re: Limit for an transaction

   Martijn van Oosterhout <kleptog@cupid.suninternet.com> — 2000-06-27T14:17:14Z

   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
   
   Usually that appears right after one of the queries you
   did failed for some reason (usually a typo in the query).
   Since the query didn't complete sucessfully it must be aborted,
   and this it ignores all queries until END.
   -- 
   Martijn van Oosterhout <kleptog@cupid.suninternet.com>
   http://cupid.suninternet.com/~kleptog/