Re: [PATCHES] Continue transactions after errors in psql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] Continue transactions after errors in psql
Date
Msg-id 2082.1114527469@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] Continue transactions after errors in psql  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
>> BEGIN;
>> \begin_ignore_error
>> DROP TABLE foo;
>> \end_ignore_error
>> CREATE ...
>> ...
>> COMMIT;

> That seems awful noisy. Why not just:

>        BEGIN:
>        DROP TABLE foo;
>        ERROR: table foo does not exist;
>        CONTINUE;
>        etc....

Well, ignoring questions of how we choose to spell the commands, the
thing I'd not like about the second alternative is that it doesn't
afford any control over the number of statements rolled back upon
error.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: btree_gist regression tests failing in 8.0 branch?
Next
From: Andrew Dunstan
Date:
Subject: Re: [PATCHES] Continue transactions after errors in psql