grupos wrote:
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.
Hmm - works here (Linux, 7.4.7)
CREATE TABLE lotest4 (description varchar, picture lo) WITHOUT OIDS;
INSERT INTO lotest4 (description) VALUES ('1');
SELECT * FROM lotest4;
description | picture
-------------+---------
1 |
Are you sure table "test" looks like that?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
