Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90]) by hub.org (8.9.2/8.9.1) with ESMTP id LAA04923; Thu, 25 Feb 1999 11:48:14 -0500 (EST) (envelope-from michael.davis@prevuenet.com) Received: from prevuepo1.prevuenet.com (prevuepo1.uvsg.com [192.40.65.44]) by corppo1.uvsg.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2232.9) id FS6Y3GJ7; Thu, 25 Feb 1999 10:46:49 -0600 Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2232.9) id <1X3LWGMB>; Thu, 25 Feb 1999 10:49:47 -0600 Message-ID: <93C04F1F5173D211A27900105AA8FCFC1451F8@lambic.prevuenet.com> From: Michael Davis To: "'pgsql-interfaces@postgreSQL.org'" , pgsql postgres , pgsql-hackers@postgreSQL.org Subject: RE: [INTERFACES] Foreign Keys Date: Thu, 25 Feb 1999 10:45:41 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain Excellent! I will start working on it. -----Original Message----- From: Byron Nikolaidis [SMTP:byronn@insightdist.com] Sent: Thursday, February 25, 1999 8:38 AM To: Michael Davis Cc: 'pgsql-interfaces@postgreSQL.org'; pgsql postgres; pgsql-hackers@postgreSQL.org Subject: Re: [INTERFACES] Foreign Keys Michael Davis wrote: > 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 > The driver does support SQLForeignKeys. It does say it supports this function in SQLFunctions. However, the current implementation is based on the SPI/trigger stuff from the pg_trigger table. If you don't have any trigger info, then SQLForeignKeys will not report anything. This is most likely the problem. Byron