Re: Large Object => invalid input syntax for integer: ""

grupos wrote:
> Hi Adam,
>
> I am sorry for the misunderstanding, when I compose the e-mail I forgot
> the ' ' on the 1 BUT the error is the same, I made:
> INSERT INTO test VALUES ('1')
>
> and I get the error:
> ERROR: invalid input syntax for integer: ""
>
> I am sure that there is some problem with LO.

Hmm - works here (Linux, 7.4.7)

CREATE TABLE lotest4 (description varchar, picture lo) WITHOUT OIDS;
INSERT INTO lotest4 (description) VALUES ('1');
SELECT * FROM lotest4;
description | picture
-------------+---------
1 |

Are you sure table "test" looks like that?
--
Richard Huxton
Archonet Ltd