Postgres Pro
Downloads
Home   >   mailing lists

Does psql -f quit insertion after an error in a statement has been detected? - Mailing list pgsql-general

From Wang, Mary Y
Subject Does psql -f quit insertion after an error in a statement has been detected?
Date
Msg-id FA20D4C4FEBFD148B1C0CB09913825FC04589DD9CE@XCH-SW-06V.sw.nos.boeing.com
Whole thread Raw
Responses Re: Does psql -f quit insertion after an error in a statement has been detected?  (John R Pierce <pierce@hogranch.com>)
Re: Does psql -f quit insertion after an error in a statement has been detected?  (Vick Khera <vivek@khera.org>)
Re: Does psql -f quit insertion after an error in a statement has been detected?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Tree view 
Hi,

I'm using a psql -f command to reload the data from a dump file.  I noticed that some tables are not populated with any
rows(I mean 0 rows), yet, if I manually insert a row (actually just copy an INSERT statement from that input file) in
theinteractive terminal, that row was added with no problem.  So my question "does psql -f quits inserting rows for a
tablewhen it detects there is an error in a statement?".  The impression that I got is that even though other rows
mightnot have any errors, but psql -f seems just quits after it detects an error in a row. 

Am I missing something here?
Thanks
Mary

pgsql-general by date:

Previous
From: Nilesh Govindarajan
Date:
Subject: Re: Difference between these two queries ?
Next
From: John R Pierce
Date:
Subject: Re: Does psql -f quit insertion after an error in a statement has been detected?