From: Michael Davis <michael.davis@prevuenet.com>
To: 'pgsql-interfaces@postgreSQL.org' <pgsql-interfaces@postgreSQL.org>
To: pgsql postgres <pgsql-sql@postgreSQL.org>
To: pgsql-hackers@postgreSQL.org
Subject: Foreign Keys
Date: Thu, 25 Feb 1999 09:32:20 -0600
Message-ID: <93C04F1F5173D211A27900105AA8FCFC1451F4@lambic.prevuenet.com> (raw)
What is the possibility of recording foreign keys (a partial foreign key
implementation) in the database such that the ODBC interface can correctly
report them to client applications? This would require an enhancement to
Postgres and to the ODBC driver for Postgres. I have a problem with Access
97 not working properly with forms that contain sub forms representing
parent/child or master/detail tables. For example: orders and orderlines.
I think this is caused by the lack of foreign key support. I am basing this
conclusion on the SQL statement that Access sent through ODBC when looking
up records for the sub form. The where clause of the SQL statement was
based on the primary key of the child or detail table. The where clause
needs to be based on the column that is linked to the parent or master
table. I already have indexes installed on both the primary key and the
field that links to the master/parent table.
I am willing to explore a work around and/or help with these enhancements.
This issue, at least for the moment, appears to be a show stopper for me.
Any Suggestions?
Thanks, Michael
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: michael.davis@prevuenet.com, pgsql-interfaces@postgreSQL.org, pgsql-hackers@postgreSQL.org
Subject: Re: Foreign Keys
In-Reply-To: <93C04F1F5173D211A27900105AA8FCFC1451F4@lambic.prevuenet.com>
References: <93C04F1F5173D211A27900105AA8FCFC1451F4@lambic.prevuenet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox