Re: ERROR: current transaction is aborted, queries ignored - Mailing list pgsql-general

From Annabelle Desbois
Subject Re: ERROR: current transaction is aborted, queries ignored
Date
Msg-id 3F165BBF.6090605@regie-france.com
Whole thread Raw
In response to ERROR: current transaction is aborted, queries ignored until end of transaction block  (Annabelle Desbois <a.desbois@regie-france.com>)
List pgsql-general
That's ok I found the problem :
BEGIN WORK
ERROR:  Cannot insert a duplicate key into unique index cde_lig_pkey
ERROR:  current transaction is aborted, queries ignored until end of
transaction block
BEGIN WORK

I forgot a ROLLBACK...

cia

Annabelle



Annabelle Desbois wrote:

> 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.desbois@regie-france.com
----------------------------------------



pgsql-general by date:

Previous
From: Annabelle Desbois
Date:
Subject: ERROR: current transaction is aborted, queries ignored until end of transaction block
Next
From: Florian Weimer
Date:
Subject: Re: IPv4 addresses, unsigned integers, space