Re: int8 foreign key in Access subform yields ODBC error on - Mailing list pgsql-odbc

Brendan LeFebvre wrote:
>
> Postgres table "item" has int8 primary key "item_id".
>
> Postgres table "image" has int8 foreign key "item" referencing
> "item"->"item_id".
>
> Table "item" is represented on  an Access form "item".
>
> The form has a subform for the records in "image."
>
> If form is opened with an empty "item" table, or if table is populated and
> "New Record" button is pressed, error dialog "Error: ODBC call failed"
> appears.
>
> PsqlODBC log is attached. Here are the pertinent lines:
>
> conn=47268416, query='SELECT "Item"."image_id" FROM "image" "Item"
> WHERE ( '' = "item" ) '

This where clause causes the following error.

> ERROR from backend during send_query: 'ERROR:  Bad int8 external
> representation ""'

Please send me the Mylog output directly.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/