Skip site navigation (1) Skip section navigation (2)

Re: int8 foreign key in Access subform yields ODBC error on

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Brendan LeFebvre <brendanl(at)iname(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: int8 foreign key in Access subform yields ODBC error on
Date: 2002-07-18 00:13:27
Message-ID: 3D360827.E3E110D9@tpf.co.jp (view raw or flat)
Thread:
Lists: 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/

In response to

Responses

pgsql-odbc by date

Next:From: BrendaDate: 2002-07-18 04:21:55
Subject: Version info
Previous:From: Thomas SchrayDate: 2002-07-17 08:17:22
Subject: test odbc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group