Re: Limit for an transaction

From: "John Huttley" <John(at)mwk(dot)co(dot)nz>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Limit for an transaction
Date: 2000-06-26 19:08:36
Message-ID: 005401bfdfa1$ee884560$1401a8c0@MWK.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dale Anderson 2000-06-26 19:31:06 DateTime fields
Previous Message Ole Gjerde 2000-06-26 18:57:49 Re: Conversion from MS Access to Postgresql