SQLForeignKeys bugs

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@mcbride.name



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: SQLForeignKeys bugs

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@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

Re: SQLForeignKeys bugs

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@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
>
>


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: SQLForeignKeys bugs

--=====================_23243750==.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed


Dear Hiroshi Inoue,

The files in PSQLODBCA.ZIP did not help at all.

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.

Thank you.

Blake McBride


At 08:54 AM 8/18/2006, Hiroshi Inoue wrote:
>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@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
>>
>
>

--=====================_23243750==.ALT
Content-Type: text/html; charset="us-ascii"





Dear Hiroshi Inoue,


The files in PSQLODBCA.ZIP did not help at all.


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.


Thank you.


Blake McBride




At 08:54 AM 8/18/2006, Hiroshi Inoue wrote:

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@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