Re: Large Object => invalid input syntax for integer: ""
От | Sean Davis |
---|---|
Тема | Re: Large Object => invalid input syntax for integer: "" |
Дата | |
Msg-id | 000001c56add$edf74890$5179f345@WATSON обсуждение исходный текст |
Ответ на | Re: Large Object => invalid input syntax for integer: "" (Adam Witney <awitney@sgul.ac.uk>) |
Список | pgsql-general |
----- Original Message ----- From: "Adam Witney" <awitney@sgul.ac.uk> To: "grupos" <grupos@carvalhaes.net>; "pgsql-general" <pgsql-general@postgresql.org> Sent: Monday, June 06, 2005 8:17 AM Subject: Re: [GENERAL] Large Object => invalid input syntax for integer: "" > 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'); > And do you need: INSERT INTO test (description) VALUES ('1'); Sean
В списке pgsql-general по дате отправления: