From: | Douglas McNaught <doug(at)mcnaught(dot)org> |
---|---|
To: | grupos <grupos(at)carvalhaes(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Large Object => invalid input syntax for integer: "" |
Date: | 2005-06-06 12:33:39 |
Message-ID: | m2zmu33brw.fsf@Douglas-McNaughts-Powerbook.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
grupos <grupos(at)carvalhaes(dot)net> writes:
> 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: ""
This means you're trying to insert an integer value into the
"description" column, which is text. It has nothing to do with large
objects.
To insert an LO into a database, you do the following:
BEGIN a transaction
Call lo_create() to make a new large object. The return value is the
OID of the LO, which you will need later.
Call lo_write() and lo_close() to put data into the LO
Insert the OID you got from lo_create() in the referencing column
("picture", in your case)
COMMIT the transaction
It's a little annoying but that's how it works.
-Doug
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2005-06-06 12:44:09 | Re: Large Object => invalid input syntax for integer: "" |
Previous Message | Adam Witney | 2005-06-06 12:17:36 | Re: Large Object => invalid input syntax for integer: "" |