Skip site navigation (1) Skip section navigation (2)

Re: SQLForeignKeys bugs

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:54:36
Message-ID: 44E5C69C.3010601@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Hiroshi Inoue wrote:
> Please try the dll at
>   http://www.geocities.jp/inocchichichi/index.html .
Oops my mistake. The URL is
http://www.geocities.jp/inocchichichi/psqlodbc/index.html .

regards,
Hiroshi Inoue
>
> 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
>
> ---------------------------(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

Responses

pgsql-odbc by date

Next:From: noreplyDate: 2006-08-18 13:56:36
Subject: [ psqlodbc-Bugs-1000708 ] SQLPrimaryKeys missing PK_NAME is NULL
Previous:From: Hiroshi InoueDate: 2006-08-18 13:46:29
Subject: Re: SQLForeignKeys bugs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group