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

----- Original Message -----
From: "Adam Witney" <awitney@sgul.ac.uk>
To: "grupos" <grupos@carvalhaes.net>; "pgsql-general"
<pgsql-general@postgresql.org>
Sent: Monday, June 06, 2005 8:17 AM
Subject: Re: [GENERAL] Large Object => invalid input syntax for integer: ""


> On 6/6/05 4:58 am, "grupos" <grupos@carvalhaes.net> wrote:
>
>> I need to use large objects BUT I am having problemns... I instaled
>> PostgreSQL 8.0.3 windows version with lo module.
>>
>> first, I created the table below:
>> CREATE TABLE test
>> (
>> description varchar(20),
>> picture lo
>> )
>> WITHOUT OIDS;
>>
>> After trying to make one insert without value for the lo I get the error
>> below:
>>
>> INSERT INTO test VALUES (1);
>>
>> ERROR:  invalid input syntax for integer: ""
>>
>> Which value I can put on the default of the lo to solve this ? I alreday
>> tryed -1, 0, 1, null but nothing works...
>>
>> Why this problem?
>
> I think the problem is nothing to do with lo, you are trying to insert an
> integer into a varchar field, try
>
> INSERT INTO test VALUES ('1');
>

And do you need:

INSERT INTO test (description) VALUES ('1');

Sean