[ psqlodbc-Bugs-1000707 ] SQLTables SQL_ALL_SCHEMAS duplicate schema names

Bugs item #1000707, was opened at 2006-08-14 21:10
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10007 07&group_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Farid Zidan (faridz)
Assigned to: Hiroshi Inoue (hinoue)
Summary: SQLTables SQL_ALL_SCHEMAS duplicate schema names

Initial Comment:
Executing SQLTables with SQL_ALL_SCHEMAS tabletype parameter the resultset has repeating/duplicate schema names. Should return one row for each schema in the database

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

Comment By: Farid Zidan (faridz)
Date: 2006-12-04 16:39

Message:
This now works. Also [#1000706] works. Thanks.

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

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-12-04 03:31

Message:
Please try the attached dll.
Please try it for [#1000706] also.

regards,
Hiroshi Inoue

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

Comment By: Farid Zidan (faridz)
Date: 2006-12-01 13:59

Message:
I am calling SQLTables:

rc = ::SQLTables( pSQL->Gethstmt(),
( SQLCHAR * ) "", //szTableCat,
( SQLSMALLINT ) 0, //cbTableCat,
( SQLCHAR * ) "%", // SQL_ALL_SCHEMAS
szTableSchem,
( SQLSMALLINT ) 1, //cbTableSchem,
( SQLCHAR * ) "", //szTableName,
( SQLSMALLINT ) 0, //cbTableName,
( SQLCHAR * ) "", //szTableType,
( SQLSMALLINT ) 0 /*cbTableType*/ );

return code is 0, but then you get SQL_NO_DATA_FOUND when
fetching the resultset rows

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

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-12-01 06:56

Message:
How are you calling SQLGetInfo concretely ?

regards,
Hiroshi Inoue

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

Comment By: Farid Zidan (faridz)
Date: 2006-12-01 05:08

Message:
Driver 8.02.02.00 Now returns no rows at all

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

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-08-19 00:30

Message:
Please try the dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html .

regards,
Hiroshi Inoue

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

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match