Re: [GENERAL] ERROR: current transaction is aborted, queries ignored

2003-07-18 Thread scott.marlowe
Ahhh. Glad you got it working. I can't wait for subtransactions to come along. Feel free to ask questions, it's tough at first getting used to the way postgresql does things, but rewarding once you start to get it. On Fri, 18 Jul 2003, Annabelle Desbois wrote: Hi, In fact I forgot the

[GENERAL] ERROR: current transaction is aborted, queries ignored until endof transaction block

2003-07-17 Thread Annabelle Desbois
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

Re: [GENERAL] ERROR: current transaction is aborted, queries ignored

2003-07-17 Thread Annabelle Desbois
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: