The files in PSQLODBC35W.ZIP fixed the DELETE_RULE problem and the missing FK_NAME problems. However, I still experience duplicate records in the return set.
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
---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly