Re: [SQL] NOTICE: (transaction aborted): queries ignored until END - Mailing list pgsql-general

From neko@kredit.sth.szif.hu
Subject Re: [SQL] NOTICE: (transaction aborted): queries ignored until END
Date
Msg-id Pine.LNX.4.10.9912191035340.2754-100000@kredit.sth.szif.hu
Whole thread Raw
In response to NOTICE: (transaction aborted): queries ignored until END  (Alex Guryanow <gav@nlr.ru>)
List pgsql-general
On Sun, 19 Dec 1999, Alex Guryanow wrote:
>                 NOTICE:  (transaction aborted): queries ignored until
> What means this message? And why this happens?
If an error occured inside a transaction, the whole transaction will be
droped. If the first query fails it is the simplest way to do nothing with
subsequent querys. (and the first action of course will be rollbacked)

If you want know what happend, you need look for the error message, before
the first "transaction aborted" notice.

--
 nek;(


pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: [GENERAL] NOTICE: (transaction aborted): queries ignored until END
Next
From: Elmar.Haneke@gmx.de
Date:
Subject: Re: [GENERAL] making 'like' queries quicker