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

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: grupos <grupos(at)carvalhaes(dot)net>
Cc: Adam Witney <awitney(at)sgul(dot)ac(dot)uk>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Large Object => invalid input syntax for integer: ""
Date: 2005-06-06 13:37:32
Message-ID: m2mzq338tf.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

grupos <grupos(at)carvalhaes(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message grupos 2005-06-06 13:50:09 Re: Large Object => invalid input syntax for integer: ""
Previous Message Douglas McNaught 2005-06-06 13:31:34 Re: Large Object => invalid input syntax for integer: ""