Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_atoi: error in.....: can't parse..." - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: pg_atoi: error in.....: can't parse..."
Date
Msg-id Pine.LNX.4.44.0309020001050.26223-100000@peter.localdomain
Whole thread Raw
In response to pg_atoi: error in.....: can't parse..."  ("stessy" <stessydelcroix@tiscali.be>)
List pgsql-admin
Tree view 
stessy writes:

> I have this error "pg_atoi: error in "PARC INDUSTRIEL": can't parse
> "PARC INDUSTRIEL" "  when I try to copy data from file to database.

The copy is seeing the value "PARC INDUSTRIEL" while it is trying to fill
a numerical column.  Make sure the order and type of your columns matches.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-admin by date:

Previous
From: Renney Thomas
Date:
Subject: Re: Prompts in psql
Next
From: "Yudha Setiawan"
Date:
Subject: Still confusing with "LISTEN,UNLISTEN,NOTIFY" Command.