Sorry
<<etalverif.txt>>
Michel BELLON
LCIE - Informatique appliquée
33 (0)1 40 95 60 35
> -----Message d'origine-----
> De: Stephan Szabo [SMTP:[EMAIL PROTECTED]]
> Date: lundi 8 octobre 2001 18:15
> À: BELLON Michel
> Cc: [EMAIL PROTECTED]
> Objet: Re: [BUGS] Restoring table with array
>
>
>
> On Mon, 8 Oct 2001, BELLON Michel wrote:
>
> > 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
>
> Can you send a complete example? The given one inherits from
> a non-existant table. Did you perhaps change etalverif at all?
>
--
-- Selected TOC Entries:
--
\connect - bellon
--
-- TOC Entry ID 2 (OID 188382)
--
-- Name: etalverif Type: TABLE Owner: bellon
--
CREATE TABLE "etalverif" (
"nodossier" character varying(30),
"noappareil" integer,
"nocertif" character varying(14) NOT NULL,
"etal_verif" boolean,
"proceduremet" character varying(15),
"operateur" integer,
"lieu" character varying(5),
"datedeb" date,
"datefin" date,
"temperature" real,
"hygrometrie" real,
"pression" real,
"temperature_inc" real,
"hygrometrie_inc" real,
"pression_inc" real,
"etalons" text[],
"documentgenere" boolean,
"datedocument" date,
"referencemaquette" character varying(20),
"urldocument" character varying(60),
"datecreat" timestamp with time zone DEFAULT now(),
"datemodif" timestamp with time zone DEFAULT now(),
"opersource" character varying(6) DEFAULT "current_user"(),
"phrase" integer
);
--
-- TOC Entry ID 3 (OID 188382)
--
-- Name: etalverif Type: ACL Owner:
--
REVOKE ALL on "etalverif" from PUBLIC;
GRANT SELECT on "etalverif" to PUBLIC;
GRANT ALL on "etalverif" to "bellon";
GRANT ALL on "etalverif" to "manceau";
GRANT ALL on "etalverif" to GROUP "metradmin";
--
-- Data for TOC Entry ID 5 (OID 188382)
--
-- Name: etalverif Type: TABLE DATA Owner: bellon
--
COPY "etalverif" FROM stdin;
\N \N \N \N \N \N \N \N \N \N
\N \N \N \N \N \N \N \N \N 2001-09-06
13:04:46+02 2001-09-06 13:04:46+02 mancea 1
\.
--
-- TOC Entry ID 4 (OID 188382)
--
-- Name: "etalverif_pkey" Type: INDEX Owner: bellon
--
CREATE UNIQUE INDEX "etalverif_pkey" on "etalverif" using btree ( "nocertif"
"varchar_ops" );
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
