ERROR: current transaction is aborted, queries ignored until end of transaction block

From: Annabelle Desbois <a(dot)desbois(at)regie-france(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: current transaction is aborted, queries ignored until end of transaction block
Date: 2003-07-17 07:22:57
Message-ID: 3F164ED1.5050301@regie-france.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

"ERROR: current transaction is aborted, queries ignored until end of
transaction block"
This error occurs after a ROLLBACK in a PHP script.
All the next queries fail, so what's wrong ?
Why the ROLLBACK isn't the end of a transaction block ?

Apache 1.3.26
PHP 4.3.0
PostgreSQL 7.3.1

Thx for your help

Annabelle

--
----------------------------------------
Annabelle DESBOIS
SA REGIE FRANCE
Village informatique - BP 3002
17030 La Rochelle CEDEX
tel: 05.46.44.75.76
fax: 05.46.45.34.17
e-mail: a(dot)desbois(at)regie-france(dot)com
----------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Annabelle Desbois 2003-07-17 08:18:07 Re: ERROR: current transaction is aborted, queries ignored
Previous Message Richard Huxton 2003-07-17 07:11:30 Re: selects during vacuum