Re: [BUGS] pg_restore error checking

2006-01-20 Thread Tom Lane
Stephen Frost <[EMAIL PROTECTED]> writes: > It seems like pg_restore really should be able to handle COPY errors > correctly by skipping to the end of the COPY data segment when the > initial COPY command comes back as an error. Send a patch ;-) regards, tom lane --

[BUGS] pg_restore error checking

2006-01-20 Thread Stephen Frost
Greetings, pg_restore doesn't handle errors very well. While attempting to upgraded a database from 8.0 to 8.1 there were some errors creating some tables because 8.0 had PostGIS installed (along with some tables) and 8.1 did not. This also meant that attempts to load the tables which