Re: ERROR: current transaction is aborted, queries ignored

Поиск
Список
Период
Сортировка
От Annabelle Desbois
Тема Re: ERROR: current transaction is aborted, queries ignored
Дата
Msg-id 3F165BBF.6090605@regie-france.com
обсуждение исходный текст
Ответ на ERROR: current transaction is aborted, queries ignored until end of transaction block  (Annabelle Desbois <a.desbois@regie-france.com>)
Список 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 по дате отправления:

Предыдущее
От: Annabelle Desbois
Дата:
Сообщение: ERROR: current transaction is aborted, queries ignored until end of transaction block
Следующее
От: Florian Weimer
Дата:
Сообщение: Re: IPv4 addresses, unsigned integers, space