Re: Can you help solve restore problem? - Mailing list pgsql-general

From Ennio-Sr
Subject Re: Can you help solve restore problem?
Date
Msg-id 20041123231805.GA4397@Ennio-(Sr)@WouldBe-ei.hnet
Whole thread Raw
In response to Re: Can you help solve restore problem?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Can you help solve restore problem?
List pgsql-general
* Tom Lane <tgl@sss.pgh.pa.us> [231104, 14:37]:
> Ennio-Sr <nasr.laili@tin.it> writes:
> > This is an extract of the dump file:
>
> [...]
>
> If that is the correct analysis then the easiest fix is probably to edit
> the COPY commands to add WITH NULL AS '-' (this assumes that you don't
> have any fields where '-' would actually be the value).
>

> > May I ask how to 'edit the COPY commands'? Perhaps you mean to edit the
> > dump file and add "WITH NULL AS '-' " ?

Mmmh, I tried to add that in the dump file (at the end of the COPY
command) and got these errors:
You are now connected as new user "ennio"
SET
ERROR: relation "dep_tit" already exists
ERROR: relation "s_cod_rif" already exists     # this is a sequence
ERROR: relation "gar_tit" already exists
ERROR: syntax error at or near "Data" at charachter 4
ERROR: syntax error at or near "Type" at charachter 2
ERROR: syntax error at or near "Schema" at charachter 2
ERROR: syntax error at or near "Owner" at charachter 2
invalid comman \.
ERROR: syntax error at or near "1" at character 1

I also tried to cut the last two columns to no avail.
May be a should correct the original table before dumping it?

Regards,
    Ennio

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.   \\?//
 Fa' qualche cosa di cui non sei capace!"  (diceva Henry Miller) ]    (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that.              )=(
 Do something you aren't good at!" (as Henry Miller used to say) ]

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Upcoming Changes to News Server ...
Next
From: Ennio-Sr
Date:
Subject: Re: Can you help solve restore problem?