RE: transaction and insert

Поиск
Список
Период
Сортировка
От Vianello, Daniel A
Тема RE: transaction and insert
Дата
Msg-id d10cac6a5deb49c591871e92d1a590ad@NCEMEXGP001.CORP.CHARTERCOM.com
обсуждение исходный текст
Ответ на Re: transaction and insert  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs

The error is : ERROR: invalid input syntax for integer:

 

Server log for PostgreSQL or, probably more usefully, the application log of the problem that sending what appears to be an empty string and expecting the server to convert that into an integer.  The empty string cannot be cast to integer, only numbers and NULL can be.

 

This can occur when bulk-uploading data from with decimal numbers, too.  In other words ‘0’ can be cast as an integer, but ‘0.0’, when found in the same column, cannot.

 

The contents of this e-mail message and
any attachments are intended solely for the
addressee(s) and may contain confidential
and/or legally privileged information. If you
are not the intended recipient of this message
or if this message has been addressed to you
in error, please immediately alert the sender
by reply e-mail and then delete this message
and any attachments. If you are not the
intended recipient, you are notified that
any use, dissemination, distribution, copying,
or storage of this message or any attachment
is strictly prohibited.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: transaction and insert
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: transaction and insert