[ psqlodbc-Bugs-1010397 ] SQLForeignKeys no rows returned

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1010397 ] SQLForeignKeys no rows returned
Date: 2009-11-18 22:02:09
Message-ID: 20091118220209.EE03C1071FC8@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Bugs item #1010397, was opened at 2008-05-19 15:58
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010397&group_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Farid Zidan (faridz)
Assigned to: Hiroshi Inoue (hinoue)
Summary: SQLForeignKeys no rows returned

Initial Comment:
PostgreSQL ANSI 8.03.02.00 Windows XP.

This was not an issue with 8.02 driver

SQLRETURN rc = ::SQLForeignKeys(
pSQL->Gethstmt(),
NULL, 0,
NULL, 0,
NULL, 0,
( SQLCHAR * ) ( *szTableCat ? szTableCat : NULL ),
( SQLSMALLINT ) cbTableCat,
( SQLCHAR * ) ( *szTableSchem ? szTableSchem : NULL ),
( SQLSMALLINT ) cbTableSchem,
( SQLCHAR * ) szTableName,
( SQLSMALLINT ) cbTableName );

----------------------------------------------------------------------

Comment By: Farid Zidan (faridz)
Date: 2009-11-18 21:03

Message:
Tested with 08.04.0100. All appears to be fine. This issue can
be closed.

----------------------------------------------------------------------

Comment By: Farid Zidan (faridz)
Date: 2009-01-04 04:39

Message:
Verified fix using 8.03.04.01. Looks good. Thanks.

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2009-01-04 02:55

Message:
OK I've just committed another change.
Please try the the drivers on testing for 8.3.0401 at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?

----------------------------------------------------------------------

Comment By: Farid Zidan (faridz)
Date: 2008-12-31 16:33

Message:
Tested again with 8.03.04 and this appears to be fixed.
However, the update rule and delete rule info is incorrect.
Both are returning 'no action' instead of 'restrict'

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2008-05-24 00:06

Message:
Hmm seems there were some implmentation changes around referential integrity at server side.
Could you please try the drivers on testing for 8.3.0201 at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
.

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010397&group_id=1000125

Browse pgsql-odbc by date

  From Date Subject
Next Message noreply 2009-11-18 22:08:45 [ psqlodbc-Bugs-1010731 ] Incorrect info for varchar(255), text columns
Previous Message noreply 2009-11-18 21:21:14 [ psqlodbc-Bugs-1010731 ] Incorrect info for varchar(255), text columns