Diff to fix SQLForeignKeys in ODBC
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
Attachments:
info.c.difftext/plain; charset=US-ASCII; name=info.c.diffDownload+178-293
Oops, had my diff args backwards -- here is the correct patch...
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Wed, 6 Dec 2000, Michael Fork wrote:
Show quoted text
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.htmProgram 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
Attachments:
info.c.difftext/plain; charset=US-ASCII; name=info.c.diffDownload+293-178
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.htmProgram 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