Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group