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

RE: [INTERFACES] Foreign Keys

From: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
To: "'Byron Nikolaidis'" <byronn(at)insightdist(dot)com>
Cc: "'pgsql-interfaces(at)postgreSQL(dot)org'" <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: RE: [INTERFACES] Foreign Keys
Date: 1999-02-25 22:40:14
Message-ID: 93C04F1F5173D211A27900105AA8FCFC145200@lambic.prevuenet.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
The trigger is installed on orders and would have no idea that this trigger
ties to orderlines.  How would Access or the ODBC driver know that this is
the equivalent to a foreign key constraint.  Seems to that I may to alter
the trigger so that the ODBC driver and Access see the trigger as a foreign
key constraint.  Should the trigger need to be applied to orderlines instead
of orders?  What is needed to actually tie the orderlines table to the
orders table?

Thanks, Michael

	-----Original Message-----
	From:	Byron Nikolaidis [SMTP:byronn(at)insightdist(dot)com]
	Sent:	Thursday, February 25, 1999 2:12 PM
	To:	Michael Davis
	Cc:	'pgsql-interfaces(at)postgreSQL(dot)org'
	Subject:	Re: [INTERFACES] Foreign Keys



	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

	

pgsql-interfaces by date

Next:From: Michael DavisDate: 1999-02-25 22:46:44
Subject: RE: [INTERFACES] Foreign Keys
Previous:From: Michael DavisDate: 1999-02-25 22:36:31
Subject: RE: [INTERFACES] Foreign Keys

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