Should/does SQLForeignKeys work (8.03.02)?
От | Joost Kraaijeveld |
---|---|
Тема | Should/does SQLForeignKeys work (8.03.02)? |
Дата | |
Msg-id | 1218095464.13123.247.camel@panoramix.askesis.nl обсуждение исходный текст |
Ответы |
Re: Should/does SQLForeignKeys work (8.03.02)?
|
Список | pgsql-odbc |
Hi, I am trying to retrieve the foreign keys of/to a PostgreSQL table (PostgreSQL ODBC 8.03.02, PostgreSQL 8.3.3, unixodbc 2.2.11) using ODBC. But whatever I try I do not get any results. I assume that if I do SQLForeignKeys(hstmt, NULL, 0, /* Primary catalog */ NULL, 0, /* Primary schema */ szTable, SQL_NTS, /* Primary table */ NULL, 0, /* Foreign catalog */ NULL, 0, /* Foreign schema */ NULL, 0); /* Foreign table */ I should get all the foreign keys TO this table FROM another table. Otherwise, doing SQLForeignKeys(hstmt, NULL, 0, /* Primary catalog */ NULL, 0, /* Primary schema */ NULL, 0, /* Primary table */ NULL, 0, /* Foreign catalog */ NULL, 0, /* Foreign schema */ szTable, SQL_NTS); /* Foreign table */ should get me all the foreign keys FROM this table TO another table. BTW: I have tried it with non-null catalogs and schemas also. Is that correct, and should it work? TIA Joost
В списке pgsql-odbc по дате отправления: