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)?  (Hiroshi Inoue <inoue@tpf.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: compiling dlg_specific.c file on Sun Solaris 5.8
Следующее
От: "Adam M"
Дата:
Сообщение: Re: resolution for bug 1010313