Re: pg_restore ignore error patch - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: pg_restore ignore error patch
Date
Msg-id 1304.24.211.141.25.1081601005.squirrel@www.dunslane.net
Whole thread Raw
In response to Re: pg_restore ignore error patch  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: pg_restore ignore error patch  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-patches
Fabien COELHO said:
>
>
> I transfer some data from one server to the other. On such occasion, I
> use my laptop to connect with server X, I download the data, then I
> restore them to server Y. The versions on my laptop and both servers
> are likely to be different. My laptop is likely to have some
> development version, and the servers may be in 7.3 or 7.4.
>

What problems have you encountered other than dollar quoting?

In the most general case, ISTM you would need to teach pg_dump how to
degrade gracefully, and a m:1 sources to targets relationship suddenly
becomes m:m. I'm not convinced it is worth the trouble.

cheers

andrew



pgsql-patches by date:

Previous
From: Fabien COELHO
Date:
Subject: pg_restore ignore error patch v2
Next
From: Bruce Momjian
Date:
Subject: Re: stdin/stdout mismatch for COPY and \copy