From: Byron Nikolaidis <byronn@insightdist.com>
To: Michael Davis <michael.davis@prevuenet.com>
Cc: 'pgsql-interfaces@postgreSQL.org' <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Foreign Keys
Date: Thu, 25 Feb 1999 16:12:11 -0500
Message-ID: <36D5BCAB.4769255F@insightdist.com> (raw)
References: <93C04F1F5173D211A27900105AA8FCFC1451FC@lambic.prevuenet.com>
Michael Davis wrote:
> I have created the following trigger on the parent/master table (orders):
>
> CREATE TRIGGER Orderlines_fkey
> BEFORE DELETE OR UPDATE ON Orders FOR EACH ROW
> EXECUTE PROCEDURE check_foreign_key ();
>
> check_foreign_key() actually deletes rows from the orderlines table when
> every a row is deleted from orders. This triggers works great. Access,
> however, is still not recognizing the foreign key relationship between
> orders and orderlines. Any other suggestions?
>
> Thanks, Michael
>
Yeah, there is more we can try. First of all, we need to verify that Access
is actually calling SQLForeignKeys. Can you get a "trace" log of the
session? This would be the "sql.log" file which contains all api calls to
odbc. Make sure the file is clear beforehand. Then run the test. Quit
Access, turn tracing off and there's your logfile. You can send it to me.
It might also be helpful to have the commlog file (produced by the
driver)...usually "psqlodbc.log". It may have a process id number appended
to the filename so make sure you get the right one.
Byron
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, michael.davis@prevuenet.com
Subject: Re: [INTERFACES] Foreign Keys
In-Reply-To: <36D5BCAB.4769255F@insightdist.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