Large Object => invalid input syntax for integer: "" - Mailing list pgsql-general

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?

Regards,

Rodrigo Carvalhaes



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


pgsql-general by date:

Previous
From: Mike Rylander
Date:
Subject: Re: Fyracle?
Next
From: Adam Witney
Date:
Subject: Re: Large Object => invalid input syntax for integer: ""