From: | <noreply(at)pgfoundry(dot)org> |
---|---|
To: | noreply(at)pgfoundry(dot)org |
Subject: | [ psqlodbc-Bugs-1010397 ] SQLForeignKeys no rows returned |
Date: | 2008-12-31 16:36:37 |
Message-ID: | 20081231163637.B8F0717ADE6F@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Bugs item #1010397, was opened at 2008-05-19 11:58
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010397&group_id=1000125
Category: None
Group: None
Status: Open
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: 2008-12-31 11: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-23 20: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
From | Date | Subject | |
---|---|---|---|
Next Message | marcopb | 2009-01-02 16:31:20 | Compiling psqlODBC on Unix without postgres installation |
Previous Message | noreply | 2008-12-31 16:33:25 | [ psqlodbc-Bugs-1010397 ] SQLForeignKeys no rows returned |