Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.9.2/8.9.1) with ESMTP id QAA99278 for ; Mon, 22 Feb 1999 16:49:22 -0500 (EST) (envelope-from byronn@insightdist.com) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id QAA07957 for pgsql-interfaces@postgreSQL.org; Mon, 22 Feb 1999 16:35:28 -0500 (EST) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA21998; Mon, 22 Feb 1999 16:24:03 -0500 Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03) id AA73856; Mon, 22 Feb 1999 16:24:03 -0500 Message-Id: <36D1CB54.AAEED337@insightdist.com> Date: Mon, 22 Feb 1999 16:25:40 -0500 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Michael Contzen Cc: "'pgsql-interfaces@postgresql.org'" Subject: Re: [INTERFACES] What is SQLForeignKeys in ODBC-Driver? References: <01BE5E74.0C896220@wcontzen.dohle.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Michael Contzen wrote: > Hello, > I have a simple question: In technical information about the ODBC-driver you can find the following: > > --------------------- > Database protocols supported: Postgres 6.2, 6.3, 6.4 (configurable by datasource) > ... > Extensions*: > SQLExtendedFetch** > SQLPrimaryKeys** > SQLForeignKeys** > > ... > ** see FAQ for additional information. > ------------------------ > > The FAQ doesn't tell anything about this. I have looked into the source-code an found some code for foreign keys. > Is the a way to use foreign keys over an ODBC-link? > Kind regards, > > Yes, the driver supports SQLForeignKeys. The driver uses trigger information from the pg_trigger table to fill out the result set. That's why it says "see the FAQ", but I never got around to putting it in the FAQ. Byron