Can you help solve restore problem?

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Can you help solve restore problem?
Date: 2004-11-23 18:25:05
Message-ID: 20041123182505.GA1601@Ennio-(Sr)@WouldBe-ei.hnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all!
Trying to restore one of my db on PG-7.4.3 (on Debian-Sarge):

$ psql finanza < finanza.out

I get:
---------
[...]
ERROR: invalid input syntax for type double precision: "-"
CONTEXT: COPY dep_tit, line 1, column ultima_quot: "-"
ERROR: invalid input syntax for type double precision: "-"
CONTEXT: COPY gar_tit, line 1, column ultima_quot: "-"
setval
--------
6
(1 row)
---------

This is an extract of the dump file:

[...]
CREATE TABLE "dep_tit" (
"cod_rif" character(3),
"titolo" character varying(20),
"quantity" integer,
"costo_med_fisc" double precision,
"data_rif" date,
"ultima_quot" double precision,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
"data_ult_q" date
);

[...]

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 - -
[...] ^^^^^^ ^^^^^^
\.
----------------

As far as I can understand, the hyphen '-' is not double precision, so
PG is complaining; the question is: is there a way to get around the
problem? How can I avoid dropping those cols and reconstructing them
manually on the restored db?

Thanks for your attention.
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) ]

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Krause, Lewis 2004-11-23 19:16:16 I need to add a column to a table
Previous Message Gary L. Burnore 2004-11-23 17:57:49 Re: Rogue cmsg (was Google (was RFD: comp.databases.postgresql.*))