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

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

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000707 ] SQLTables SQL_ALL_SCHEMAS duplicate schema names
Date: 2006-12-06 16:42:09
Message-ID: 20061206164209.C6223216E91@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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=1000707&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=1000707&group_id=1000125

pgsql-odbc by date

Next:From: noreplyDate: 2006-12-06 16:42:47
Subject: [ psqlodbc-Bugs-1000706 ] SQLTables SQL_ALL_TABLE_TYPES return code 100
Previous:From: noreplyDate: 2006-12-06 16:41:38
Subject: [ psqlodbc-Bugs-1000796 ] client encoding mismatch using ANSI driver with ANSI app

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