Re: ERROR: invalid input syntax for integer: "" - Mailing list pgsql-general

From Ben Madin
Subject Re: ERROR: invalid input syntax for integer: ""
Date
Msg-id D4C14D0D-E06F-44BC-804B-48DB56104EBC@ausvet.com.au
Whole thread Raw
In response to Re: ERROR: invalid input syntax for integer: ""  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: ERROR: invalid input syntax for integer: ""  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Thanks Adrian,

On 2013-02-06, at 12:40 , Adrian Klaver <adrian.klaver@gmail.com> wrote:

> I am not seeing anything obvious.
> Is there a chance the import to the second machine did not go well?

Actually, these queries work on the machine that the import was done to =
- but not the original. However, not all is well on the development =
machine, I've sent a further email.

> Have you looked at the values for id and reportid to see if they look =
alright?

Yes, those I've scanned seem OK - I've tried some tests looking for =
nulls etc. (there are several million reports, and about 30 times as =
many results, hence I'm not posting a reproducible example - yet!)

cheers

Ben


--=20

Ben Madin

m : +61 448 887 220
e : ben@ausvet.com.au

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: ERROR: invalid input syntax for integer: "" - more confusion
Next
From: Adrian Klaver
Date:
Subject: Re: ERROR: invalid input syntax for integer: ""