From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200012102259.RAA08603@candle.pha.pa.us>
Subject: Re: [PATCHES] Diff to fix SQLForeignKeys in ODBC
In-Reply-To: <Pine.BSI.4.21.0012052333020.21333-200000@glass.toledolink.com>
	"from Michael Fork at Dec 6, 2000 00:00:09 am"
To: Michael Fork <mfork@toledolink.com>
Date: Sun, 10 Dec 2000 17:59:10 -0500 (EST)
CC: pgsql-patches@postgresql.org, pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Applied.  Thanks.


> Here is a diff to info.c in interfaces/odbc that updates SQLForeignKeys to
> return foreign key information based on the pg_trigger system table.  I
> have tested the patch with (what I believe) is all possible
> primary/foreign key combinations -- however I may have missed some, so if
> anyone feels like taking the patch for a test drive, here are some useful
> links:
> 
> SQLForeignKeys specs
> http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/dasdk/odch7j8z.htm
> 
> Program to query a database using ODBC calls
> http://www.microsoft.com/data/download_260SDK.htm
> (this is the SDK, once it is installed, goto Samples\ODBC and look at
> Admin and Odbctest)
> 
> Michael Fork - CCNA - MCP - A+
> Network Support - Toledo Internet Access - Toledo Ohio
> 
Content-Description: 

[ Attachment, skipping... ]


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026