SQLForeignKeys bugs
От | Blake McBride |
---|---|
Тема | SQLForeignKeys bugs |
Дата | |
Msg-id | 7.0.1.0.2.20060817053223.059800d8@mcbride.name обсуждение исходный текст |
Ответы |
Re: SQLForeignKeys bugs
|
Список | pgsql-odbc |
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 по дате отправления: