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

From Douglas McNaught
Subject Re: Large Object => invalid input syntax for integer: ""
Date
Msg-id m2mzq338tf.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to Re: Large Object => invalid input syntax for integer: ""  (grupos <grupos@carvalhaes.net>)
List pgsql-general
grupos <grupos@carvalhaes.net> writes:

> 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.

Try inserting an explicit NULL:

INSERT INTO test VALUES ('1', NULL);

-Doug

pgsql-general by date:

Previous
From: grupos
Date:
Subject: Re: Large Object => invalid input syntax for integer: ""
Next
From: Douglas McNaught
Date:
Subject: Re: Large Object => invalid input syntax for integer: ""