| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Annabelle Desbois <a(dot)desbois(at)regie-france(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: ERROR: current transaction is aborted, queries ignored |
| Date: | 2003-07-17 17:51:10 |
| Message-ID: | Pine.LNX.4.33.0307171150110.32527-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 17 Jul 2003, 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
Are you sure the rollback is happening? We might need to see some code,
not sure.
What I think you're saying is that this happens:
begin;
query1;
query2;
query3;
rollback;
ERROR: current transaction is aborted,
query4; <- This query now fails
IS that the sequence you're describing?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-07-17 17:51:35 | Re: selects during vacuum |
| Previous Message | Alvaro Herrera | 2003-07-17 17:26:26 | Re: Where can I find the release notes for 7.3.3? |