Re: Limit for an transaction

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(at)mteege(dot)de>
To: <pgsql-general(at)postgresql(dot)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
>