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@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');
HTH
adam
--
Esta mensagem foi verificada pelo sistema de antivírus e
acredita-se estar livre de perigo.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
