Re: Large Object => invalid input syntax for integer: "" - Mailing list pgsql-general

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