Re: execute sql script w/o stopping after error?

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Carl R(dot) Brune" <brune(at)ohio(dot)edu>, <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: execute sql script w/o stopping after error?
Date: 2006-02-02 08:37:25
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E40103DDC9@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: pgadmin-hackers-owner(at)postgresql(dot)org
> [mailto:pgadmin-hackers-owner(at)postgresql(dot)org] On Behalf Of
> Carl R. Brune
> Sent: 31 January 2006 18:33
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] execute sql script w/o stopping
> after error?
>
> Does pgadmin3 offer a way to execute sql scripts without
> stopping if an error is encountered? I've got a script
> which starts by dropping table (which may or may not exist)
> and then rebuilds it. If I execute the script with psql
> (using \i) script execution continues after errors. However
> if I try to do this with the query tool of pgadmin3 it stops
> after the drop table statement (if the table doesn't exist).

No, at present it doesn't. You can select only specific portions of your
script to run by selecting the text, and then clicking the run button
though.

Regards, Dave.

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Hiroshi Saito 2006-02-02 08:42:51 Re: [pgadmin-support] "view data" freezes up every time
Previous Message Dave Page 2006-02-02 08:21:31 Re: "view data" freezes up every time