Re: Error for insert large object

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: Error for insert large object
Дата
Msg-id 450F31A8.4020108@tpf.co.jp
обсуждение исходный текст
Ответ на Error for insert large object  ("Lemaire Vincent" <vincentlemaire@tele2.fr>)
Список 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

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Lemaire Vincent"
Дата:
Сообщение: Error for insert large object
Следующее
От: Josef Springer
Дата:
Сообщение: How can i test the installed ODBC-driver in WindowsXP