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

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@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');
>
>HTH
>
>adam
>
>
>
>


--
Esta mensagem foi verificada pelo sistema de antivírus e
 acredita-se estar livre de perigo.