From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
---|---|
To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: pg_restore ignore error patch |
Date: | 2004-04-12 11:59:34 |
Message-ID: | Pine.LNX.4.58.0404121348360.15842@sablons.cri.ensmp.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Dear Andrew,
> > 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?
If you're interested to know, there were some complaints about
the new "default_with_oids" setting, as far as I can remember.
> 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.
I don't know what is worth the trouble. I'm just reporting a "feature"
that make the tool not work properly for me. I've fixed part of
the problem and submitted a patch, and I just noted in the mail that
there was another small problem that I did not fix.
I agree that fixing this would mean redesigning the tool in depth.
That's why I did not fixed it in the patch I submitted.
My opinion would be that pg_dump should just dump the data in some raw
format, and that all syntax re-generation issues should be dealt with by
pg_restore (INSERT vs COPY, quoting, and so on). But the tool was
not resigned this way in the beginning.
--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2004-04-12 12:07:12 | Re: COPY for CSV documentation |
Previous Message | Bruno Wolff III | 2004-04-12 11:42:35 | Re: COPY for CSV documentation |