Обсуждение: pg_atoi: error in.....: can't parse..."

Поиск

Список

Период

Сортировка

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

От

"stessy"

Дата:

01 сентября 2003 г., 04:40:14

hi all,

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 2 databases have the same encoding 'LATIN1'.

The data types are all the same in two tables.

These are alls requests I use to copy data.

First database

psql gravoline

CREATE TABLE adr AS SELECT(id_client, rue::text,num::text,"code postal"::text,localite::text) from adresse;

COPY adr to '/usr/adr.sql' USING DELIMITERS '|';

Second database

psql pdg

COPY adresse FROM '/usr/adr.sql' USING DELIMITERS '|';

ps: excuse for my english.

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

От

Peter Eisentraut

Дата:

01 сентября 2003 г., 19:02:03

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: pg_atoi: error in.....: can't parse..."

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

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