----- Original Message -----
From: "Adam Witney" <awitney@xxxxxxxxxx>
To: "grupos" <grupos@xxxxxxxxxxxxxx>; "pgsql-general"
<pgsql-general@xxxxxxxxxxxxxx>
Sent: Monday, June 06, 2005 8:17 AM
Subject: Re: Large Object => invalid input syntax for integer: ""
On 6/6/05 4:58 am, "grupos" <grupos@xxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
