The sql.log file is over 5M. There are no references to foreign keys
anywhere in the log file. I noticed the following:
Orders 138:118 ENTER SQLExecDirect
UCHAR * 0x040f10f0 [ -3] "SELECT
Config, nValue FROM MSysConf\ 0"
This failed because my Postgres database does not have this table. Any idea
what MsysConf, what it contains, or how to create it? Could this have
anything to do with my Access subform problem?
From: Byron Nikolaidis [SMTP:byronn(at)insightdist(dot)com]
Sent: Thursday, February 25, 1999 2:12 PM
To: Michael Davis
Subject: Re: [INTERFACES] Foreign Keys
Michael Davis wrote:
> I have created the following trigger on the parent/master table
> 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
> every a row is deleted from orders. This triggers works great.
> however, is still not recognizing the foreign key relationship
> orders and orderlines. Any other suggestions?
> Thanks, Michael
Yeah, there is more we can try. First of all, we need to verify
is actually calling SQLForeignKeys. Can you get a "trace" log of
session? This would be the "sql.log" file which contains all api
odbc. Make sure the file is clear beforehand. Then run the test.
Access, turn tracing off and there's your logfile. You can send it
It might also be helpful to have the commlog file (produced by the
driver)...usually "psqlodbc.log". It may have a process id number
to the filename so make sure you get the right one.
pgsql-interfaces by date
|Next:||From: Kevin Meldorf||Date: 1999-02-26 00:33:00|
|Previous:||From: Michael Davis||Date: 1999-02-25 22:40:14|
|Subject: RE: [INTERFACES] Foreign Keys|