Hi all,
Restoring a table with the following file
<<restore.txt>>
I obtain the error
ERROR: pg_atoi: error in "{{0.22,0.2,10 ... etc
with INSERT INTO evtransftherm .... etc
+--------------------------------------------------------------+
| version |
+--------------------------------------------------------------+
| PostgreSQL 7.1.2 on i686-pc-cygwin, compiled by GCC 2.95.3-4 |
+--------------------------------------------------------------+
and the same with 7.1.3 on a Mandrake distribution
Help !!!
Michel BELLON
LCIE - Informatique appliquée
33 (0)1 40 95 60 35
--
-- Selected TOC Entries:
--
\connect - manceau
DROP TABLE evtransftherm;
--
-- TOC Entry ID 2 (OID 188909)
--
-- Name: evtransftherm Type: TABLE Owner: manceau
--
CREATE TABLE evtransftherm (
nu smallint,
cuf double precision[],
u_valeur double precision[],
uinc_val double precision[],
ni smallint,
sif double precision[],
i_valeur double precision[],
iinc_val double precision[],
u_mesures double precision[],
i_mesures double precision[],
reversib real,
remarque1 integer,
delai real,
tens_sec integer,
remarque2 integer,
d_av real,
d_ap real,
hf integer,
shunt integer,
remarque3 integer,
longueur character varying(5),
maxdelta real,
remarque4 integer,
longueurs character varying(5)
)
INHERITS (etalverif);
--
-- TOC Entry ID 3 (OID 188909)
--
-- Name: evtransftherm Type: ACL Owner:
--
REVOKE ALL on evtransftherm from PUBLIC;
GRANT SELECT on evtransftherm to PUBLIC;
GRANT ALL on evtransftherm to manceau;
GRANT ALL on evtransftherm to GROUP metradmin;
--
-- Data for TOC Entry ID 4 (OID 188909)
--
-- Name: evtransftherm Type: TABLE DATA Owner: manceau
--
INSERT INTO evtransftherm VALUES
(NULL,161,'L802739/A',NULL,NULL,NULL,NULL,NULL,'1999-10-14',20,60,1,0.5,5,0.1,NULL,NULL,NULL,NULL,NULL,'2001-06-14
15:40:47+02','2001-06-14
15:43:02+02','mancea',NULL,'{{0.22,0.2,10},{0.22,0.2,20},{0.22,0.2,40},{0.22,0.2,400},{0.22,0.2,1000},{0.22,0.2,4000},{0.22,0.2,10000},{0.22,0.2,20000},{0.22,0.2,50000},{0.22,0.2,100000},{0.7,0.2,10},{0.7,0.2,20},{0.7,0.2,40},{0.7,0.2,400}}');
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
