Re: execute sql script w/o stopping after error? - Mailing list pgadmin-hackers

From Dave Page
Subject Re: execute sql script w/o stopping after error?
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40103DDC9@ratbert.vale-housing.co.uk
Whole thread Raw
In response to execute sql script w/o stopping after error?  ("Carl R. Brune" <brune@ohio.edu>)
Responses Re: execute sql script w/o stopping after error?  ("Carl R. Brune" <brune@ohio.edu>)
List pgadmin-hackers

> -----Original Message-----
> From: pgadmin-hackers-owner@postgresql.org
> [mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of
> Carl R. Brune
> Sent: 31 January 2006 18:33
> To: pgadmin-hackers@postgresql.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.

pgadmin-hackers by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Patch: Query favourites
Next
From: "Hiroshi Saito"
Date:
Subject: Re: [pgadmin-support] "view data" freezes up every time