Re: transaction aborted with error - Mailing list pgsql-general

From Anand Raman
Subject Re: transaction aborted with error
Date
Msg-id 20010322210047.J7826@india-today.com
Whole thread Raw
In response to transaction aborted with error  (DaVinci <bombadil@wanadoo.es>)
List pgsql-general
I dont think so ..
Transactions need to be atomic.. Either succeed or fail.. I thik what
postgressql does is quite OK only a little irritating if u are issuing
command thru the psql terminal..

Anand
On Thu, Mar 22, 2001 at 10:15:54AM +0100, DaVinci wrote:
> Hello. I have a problem with Postgresql 7.1 beta (Debian packages).
>
> When I am in middle of transaction and there is an error, for example
> caused by trying to insert a tupla with a "not null" value without valor, I
> get error:
>
>     NOTICE: current transaction is aborted, queries ignored until end of
>    transaction block.
>
> I don't like this behaviour, is there any form of avoiding abortion of
> transaction on error?...
>
> Thanks.
>
>                                                             David
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: String REPLACE function
Next
From: Tom Lane
Date:
Subject: Re: OID as Primary Key