Re: Error for insert large object

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Lemaire Vincent <vincentlemaire(at)tele2(dot)fr>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Error for insert large object
Date: 2006-09-18 23:54:16
Message-ID: 450F31A8.4020108@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Josef Springer 2006-09-19 08:29:08 How can i test the installed ODBC-driver in WindowsXP
Previous Message Lemaire Vincent 2006-09-18 21:14:49 Error for insert large object