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

Diff to fix SQLForeignKeys in ODBC

From: Michael Fork <mfork(at)toledolink(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Diff to fix SQLForeignKeys in ODBC
Date: 2000-12-06 05:00:09
Message-ID: Pine.BSI.4.21.0012052333020.21333-200000@glass.toledolink.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-patches
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


Attachment: info.c.diff
Description: text/plain (23.6 KB)

Responses

pgsql-patches by date

Next:From: Michael ForkDate: 2000-12-06 05:08:27
Subject: Re: [PATCHES] Diff to fix SQLForeignKeys in ODBC
Previous:From: Peter BiermanDate: 2000-12-05 22:16:25
Subject: Re: darwin pgsql patches

pgsql-interfaces by date

Next:From: Michael ForkDate: 2000-12-06 05:08:27
Subject: Re: [PATCHES] Diff to fix SQLForeignKeys in ODBC
Previous:From: najeeb ahmedDate: 2000-12-06 04:57:00
Subject: source code of jdbc drivers

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