Re: Query Window: keep going after error

On 07/02/2008 15:30, Laurent Duperval wrote:

> I am currently testing some SQL scripts and I want to run the entire
> script, even if there is an error in it. Currently, it stops when there is
> an error and does not execute any of the commands in the SQL file.

At a guess, I'd say that this is because of the way PostgreSQL works,
not PgAdmin - when you execute a series of statements within a
transaction, and one of them causes an error, no following statements
will be executed until you ROLLBACK the transaction. Scripts from from
the Query Editor in PgAdmin are run within a transaction, so this is the
behaviour you are seeing.

If you want your script to continue after an error (and to be honest I
can't think of many cases where you would :-) ) you should run it from
psql, perhaps using the \i command (which runs the contents of an
external file).

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------