| From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Blake McBride <blake(at)mcbride(dot)name> |
| Cc: | pgsql-odbc(at)postgresql(dot)org, David Moore <dmoore(at)arahant(dot)com>, Ryan Kettrey <rkettrey(at)arahant(dot)com> |
| Subject: | Re: SQLForeignKeys bugs |
| Date: | 2006-08-18 13:46:29 |
| Message-ID: | 44E5C4B5.8080602@tpf.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Please try the dll at
http://www.geocities.jp/inocchichichi/index.html .
regards,
Hiroshi Inoue
Blake McBride wrote:
>
> 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 | Hiroshi Inoue | 2006-08-18 13:54:36 | Re: SQLForeignKeys bugs |
| Previous Message | noreply | 2006-08-18 13:38:49 | [ psqlodbc-Bugs-1000699 ] Problem creating TableAdapter with WHERE parameter |