Обсуждение: Error for insert large object

Поиск
Список
Период
Сортировка

Error for insert large object

От
"Lemaire Vincent"
Дата:

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 »

 

How create a large object with odbc driver in C# ?

 

Can you help me please? It’s very important for my project actually.

 

Sorry, I’m French and my English is not perfectly, I hope that you think.

 

Vincent Lemaire

 

Re: Error for insert large object

От
Hiroshi Inoue
Дата:
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