John McKown wrote: > I'm likely abusing the psql program. What I have is an awk program which > reads a file and produces a > number of INSERT INTO commands. I then feed these commands into psql to > execute them. Yes, a Perl > program would be a better idea. Anyway, sometimes the commands are rejected > due to some problem, such > as duplicate primary key. What I wish is that the psql command had a switch, > or control command, which > would say "exit from psql if anything fails". To me, this is like the BASH > "set -e" command for a > shell script. Does this sound like a useful addition. Or am I just missing > where it already exists?
Did you try "psql -v ON_ERROR_STOP=on"? Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general