Re: [GENERAL] psql: immediately exit after an error?

2004-08-11 Thread Peter Eisentraut
David Garamond wrote: > Can psql be told to exit immediately after an error (especially when > doing commands from a file, -f)? This is the default behaviour of the > mysql client, except when we give it -f option ("force"). \set ON_ERROR_STOP on Look into the psql man page for additional semanti

Re: [GENERAL] psql: immediately exit after an error?

2004-08-10 Thread Mike G
I would think that depends upon how the sql in the file is coded. You can use the RAISE NOTICE / ERROR commands to abort a function's execution. > Can psql be told to exit immediately after an error (especially when > doing commands from a file, -f)? This is the default behaviour of the > mysq

[GENERAL] psql: immediately exit after an error?

2004-08-10 Thread David Garamond
Can psql be told to exit immediately after an error (especially when doing commands from a file, -f)? This is the default behaviour of the mysql client, except when we give it -f option ("force"). The problem is, when restoring a dump, a failure at the some point might cause the subsequent comm