From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL Development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] psql and libpq fixes |
Date: | 2000-02-08 11:34:58 |
Message-ID: | Pine.GSO.4.02A.10002081233550.12742-100000@Krokodil.DoCS.UU.SE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 7 Feb 2000, Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > While we're at it, there's a setting that causes psql to stop execution of
> > a script on an error (since usually the later commands will be depending
> > on the successful completion of earlier ones). I was wondering if that
> > should be the default if you use the -f option.
>
> Sounds useful, but you can't make it the default without breaking existing
> scripts. Trivial example is this common idiom:
> DROP TABLE t1; -- in case it already exists
> CREATE TABLE t1;
> COPY ...
Oh yes, good point.
>
> In general, an existing script is not going to be written with the idea
> that psql will cut it off at the knees for provoking an error. If the
> author *does* want all the rest of the commands to be skipped on error,
> he'll just have written BEGIN and END around the whole script.
Last time I checked you couldn't roll back a create table. ;)
--
Peter Eisentraut Sernanders vaeg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2000-02-08 11:40:13 | Re: [HACKERS] New Globe |
Previous Message | Peter Eisentraut | 2000-02-08 11:32:23 | Re: [HACKERS] PostgreSQL 7 RPMs coming soon |