Re: Error for insert large object

[Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>]

Lemaire Vincent wrote:
> Hello all world, 
>
>  
>
> I work on a project c# with a postgresql database. The communication is made
> by the odbc driver. The select command is OK but I have a problem for insert
> an Image in my table. 
>
>
> The script of creation of my table is as follows:
>
>  
>
> CREATE TABLE images
>
> (
>
>   id_image int4 NOT NULL,
>
>   image bytea,
>
>   CONSTRAINT id_image PRIMARY KEY (id_image)
>
> ) 
>
> WITH OIDS;
>
> ALTER TABLE images OWNER TO postgres;
>
>  
>
> When I want insert data, I have an error how is generate by de odbc driver.
> This error is "type "lo" does not exist

Please check the bytea as LO option.

regards,
Hiroshi Inoue