Re: Can you help solve restore problem?

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [231104, 14:37]:
> Ennio-Sr <nasr(dot)laili(at)tin(dot)it> writes:
> > This is an extract of the dump file:
>
>
> > COPY dep_tit (cod_rif, titolo, quantity, costo_med_fisc, data_rif,
> > ultima_quot, data_ult_q) FROM stdin;
> > 1 Tit. a 100 3.9112 2004-07-23 - -
> > 2 Tit. b 100 4.78 2004-07-23 - -
> > [...] ^^^^^^ ^^^^^^
>
> It's pretty much impossible to believe that that's what came out of
> pg_dump originally, because "-" definitely isn't a possible output value
> for either double precision or date. The best theory I can come up with
> is that those columns were actually NULL in the source database, and
> that something somewhere along the line munged the "\N" null markers into
> "-". Does this theory seem to you to hold any water? Has the dump file
> been subjected to any indignities like being emailed or copied onto/off
> of a Windows machine?

I myself might have committed those 'indignities', maybe manually adding
the hyphen, for sure not using win$ ... :-) [It was a few months ago
and I cannot remember. Sorry to have arisen any suspect on pg ;( ]

>
> 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 '-' " ?

In the meantime, many thanks for your answer.

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) ]