| From: | Blake McBride <blake(at)mcbride(dot)name> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Cc: | David Moore <dmoore(at)arahant(dot)com>,Ryan Kettrey <rkettrey(at)arahant(dot)com> |
| Subject: | SQLForeignKeys bugs |
| Date: | 2006-08-17 11:00:09 |
| Message-ID: | 7.0.1.0.2.20060817053223.059800d8@mcbride.name |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)mcbride(dot)name
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2006-08-17 19:28:38 | Re: whitch compiler do you cho ose. |
| Previous Message | Mahesh Vyas | 2006-08-17 04:08:04 | unsubscribe |