Thread: Error for insert large object
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
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