From: | grupos <grupos(at)carvalhaes(dot)net> |
---|---|
To: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Large Object => invalid input syntax for integer: "" |
Date: | 2005-06-06 13:24:03 |
Message-ID: | 42A44E73.4010500@carvalhaes.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Regards,
Rodrigo Carvalhaes
Adam Witney wrote:
>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');
>
>HTH
>
>adam
>
>
>
>
--
Esta mensagem foi verificada pelo sistema de antivírus e
acredita-se estar livre de perigo.
From | Date | Subject | |
---|---|---|---|
Next Message | grupos | 2005-06-06 13:27:41 | Re: Large Object => invalid input syntax for integer: "" |
Previous Message | Douglas McNaught | 2005-06-06 13:21:15 | Re: transactions |