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@iol.ie
---------------------------------------------------------------