SQLForeignKeys bugs

Поиск
Список
Период
Сортировка
Искать
От
Blake McBride
Тема
SQLForeignKeys bugs
Дата
Msg-id
7.0.1.0.2.20060817053223.059800d8@mcbride.name
Список
Дерево обсуждения
SQLForeignKeys bugs Blake McBride <blake@mcbride.name>
Re: SQLForeignKeys bugs Hiroshi Inoue <inoue@tpf.co.jp>
Re: SQLForeignKeys bugs Hiroshi Inoue <inoue@tpf.co.jp>
Re: SQLForeignKeys bugs Blake McBride <blake@mcbride.name>

Greetings,

I am having a number of problems with SQLForeignKeys.
I have tried the PostgreSQL ODBC driver versions on
Windows XP Pro:

	8.01.01.02
	8.01.02.00
	8.02.00.02

I am using PostgreSQL 8.1.2 on the same machine.

The first problem is that the DELETE_RULE field is returning
SQL_CASCADE (0) when it should be
SQL_NO_ACTION(3).  In other words, the foreign key
does not have ON DELETE CASCADE yet SQLForeignKeys
return 0 in the DELETE_RULE field when it should be 3.

The second problem I noticed is that the result set returned
by SQLForeignKeys has duplicate records. This is wrong.

The third problem is that the FK_NAME field is always blank.
I need this.  (I haven't checked PK_NAME but I bet it's blank
too).

The project I am working on requires this data.

Thanks.

Blake McBride
blake@mcbride.name


В списке pgsql-odbc по дате отправления
От: Mahesh Vyas
Дата:
Сообщение: unsubscribe
От: Dave Page
Дата:
FAQ