From: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk> |
---|---|
To: | grupos <grupos(at)carvalhaes(dot)net>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Large Object => invalid input syntax for integer: "" |
Date: | 2005-06-06 12:17:36 |
Message-ID: | BEC9FD70.471DB%awitney@sgul.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 6/6/05 4:58 am, "grupos" <grupos(at)carvalhaes(dot)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');
HTH
adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Douglas McNaught | 2005-06-06 12:33:39 | Re: Large Object => invalid input syntax for integer: "" |
Previous Message | Mike Rylander | 2005-06-06 10:43:04 | Re: Fyracle? |