Re: pg_atoi: error in.....: can't parse..."

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: stessy <stessydelcroix(at)tiscali(dot)be>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_atoi: error in.....: can't parse..."
Date: 2003-09-01 22:01:52
Message-ID: Pine.LNX.4.44.0309020001050.26223-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmx(dot)net

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message 3rd. 2003-09-02 00:57:43 YOUR SITES SEARCH FEATURE DOES NOT WORK!
Previous Message Renney Thomas 2003-09-01 18:51:04 Re: Prompts in psql