RE: transaction and insert - Mailing list pgsql-bugs

From Vianello, Daniel A
Subject RE: transaction and insert
Date
Msg-id d10cac6a5deb49c591871e92d1a590ad@NCEMEXGP001.CORP.CHARTERCOM.com
Whole thread Raw
In response to Re: transaction and insert  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: transaction and insert
Next
From: "David G. Johnston"
Date:
Subject: Re: transaction and insert