From: | "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | "Adam Witney" <awitney(at)sgul(dot)ac(dot)uk>, "grupos" <grupos(at)carvalhaes(dot)net>, "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Large Object => invalid input syntax for integer: "" |
Date: | 2005-06-06 12:44:09 |
Message-ID: | 000001c56add$edf74890$5179f345@WATSON |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
----- Original Message -----
From: "Adam Witney" <awitney(at)sgul(dot)ac(dot)uk>
To: "grupos" <grupos(at)carvalhaes(dot)net>; "pgsql-general"
<pgsql-general(at)postgresql(dot)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(at)carvalhaes(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Surabhi Ahuja | 2005-06-06 12:57:03 | transactions |
Previous Message | Douglas McNaught | 2005-06-06 12:33:39 | Re: Large Object => invalid input syntax for integer: "" |