Thread: 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 Many thanks Matthias
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
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/
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 >