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

Поиск
Список
Период
Сортировка
От Wang, Mary Y
Тема Does psql -f quit insertion after an error in a statement has been detected?
Дата
Msg-id FA20D4C4FEBFD148B1C0CB09913825FC04589DD9CE@XCH-SW-06V.sw.nos.boeing.com
обсуждение исходный текст
Ответы 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>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Nilesh Govindarajan
Дата:
Сообщение: Re: Difference between these two queries ?
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Does psql -f quit insertion after an error in a statement has been detected?