Re: ERROR: current transaction is aborted, queries ignored

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(dot)desbois(at)regie-france(dot)com
----------------------------------------