| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces pgsql-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 | Content-Type | Size |
|---|---|---|
| info.c.diff | text/plain | 23.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fork | 2000-12-06 05:08:27 | Re: [PATCHES] Diff to fix SQLForeignKeys in ODBC |
| Previous Message | najeeb ahmed | 2000-12-06 04:57:00 | source code of jdbc drivers |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fork | 2000-12-06 05:08:27 | Re: [PATCHES] Diff to fix SQLForeignKeys in ODBC |
| Previous Message | Peter Bierman | 2000-12-05 22:16:25 | Re: darwin pgsql patches |