Hiroshi Inoue wrote:
> Please try the dll at
> http://www.geocities.jp/inocchichichi/index.html .
Oops my mistake. The URL is
> Hiroshi Inoue
> Blake McBride wrote:
>> I am having a number of problems with SQLForeignKeys.
>> I have tried the PostgreSQL ODBC driver versions on
>> Windows XP Pro:
>> 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
>> The project I am working on requires this data.
>> Blake McBride
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
In response to
pgsql-odbc by date
|Next:||From: noreply||Date: 2006-08-18 13:56:36|
|Subject: [ psqlodbc-Bugs-1000708 ] SQLPrimaryKeys missing PK_NAME is NULL|
|Previous:||From: Hiroshi Inoue||Date: 2006-08-18 13:46:29|
|Subject: Re: SQLForeignKeys bugs|