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

From John Huttley
Subject Re: Limit for an transaction
Date
Msg-id 005401bfdfa1$ee884560$1401a8c0@MWK.co.nz
Whole thread Raw
In response to Limit for an transaction  (Matthias Teege <matthias@mteege.de>)
List pgsql-general
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
>



pgsql-general by date:

Previous
From: igor
Date:
Subject: problems with transactions in C++Builder
Next
From: "Michael Mayo"
Date:
Subject: Re: Transactions and web applications