Re: Now PostgreSQL recovers from errors within trns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: hstenger(at)ieee(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Now PostgreSQL recovers from errors within trns
Date: 2000-07-31 15:08:03
Message-ID: 9572.965056083@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hstenger(at)adinet(dot)com(dot)uy writes:
> My goal is to make the backend accept erroneous commands, not falling
> in *ABORT STATE*, but rolling back automatically, & continue accepting
> commands.

The way you're doing it, you might as well just not use transaction
blocks at all. I don't think wiping out the effects of all preceding
commands within the transaction counts as "recovering from an error".

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Don Baccus 2000-07-31 17:05:12 Re: Now PostgreSQL recovers from errors within trns
Previous Message Karel Zak 2000-07-31 14:40:10 Re: quiet? Re: The query cache - first snapshot (long)