Re: [GENERAL] transaction aborted with error

2001-03-22 Thread Anand Raman

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 [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



[GENERAL] transaction aborted with error

2001-03-22 Thread DaVinci

 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 [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly