Обсуждение: 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
>