resend: Trouble with pg_dump in 7.3.4

From: Frank Voellmann <fvoellma(at)cisco(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: resend: Trouble with pg_dump in 7.3.4
Date: 2004-07-14 19:47:27
Message-ID: 4.3.2.7.2.20040714154615.02b195a8@funnel.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2004-07-14 20:06:47 Re: resend: Trouble with pg_dump in 7.3.4
Previous Message Frank Voellmann 2004-07-14 19:39:54 Trouble with pg_dump in 7.3.4