Re: resend: Trouble with pg_dump in 7.3.4

I can not reproduce the failure here.

---------------------------------------------------------------------------

Frank Voellmann wrote:
> resend after joining list ...
>
> >I'm using the following to backup a table from a database
> >
> >pg_dump --table=tableName --clean --format p dbName
> >
> >The file produced has all lines preceded by a space. Only the COPY such as
> >this ...
> >
> > COPY rr_config (a, b, c, d, e, f, g, h, i, j, k, l, m, n, o) FROM stdin;
> > 69 2 \N \N mydevice ahash 1 \N
> > \N mydevice#10.86.209.205 \N \N \N 68 63
> > \.
> >
> >seems to care. I get these errors:
> >
> >ERROR: copy: line 2, Bad numeric input format ' '
> >lost synchronization with server, resetting connection
> >
> >manually removing the space before the "\." fixes the problem.
> >
> >Is there a workaround?
> >
> >Thanks,
> >Frank

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073