Received: from etm.at (ns.etm.at [212.88.180.5])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA82186
	for <pgsql-interfaces@postgresql.org>;
	Tue, 25 Jan 2000 10:29:20 -0500 (EST)
	(envelope-from rlintner@etm.co.at)
Received: by fwetm.etm.at id <115202>; Tue, 25 Jan 2000 16:28:22 +0100
Message-Id: <00Jan25.162822cet.115202@fwetm.etm.at>
From: "Robert Lintner" <rlintner@etm.co.at>
To: <pgsql-interfaces@postgresql.org>
Subject: SQLStatistics problem
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-Msmail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3612.1700
X-Mimeole: Produced By Microsoft MimeOLE V4.72.3612.1700
Date: Tue, 25 Jan 2000 16:28:21 +0100

Hi,

i've got a problem with ODBC command SQLStatistics ( and SQLColumns).

I am using PostgreSQL Driver v06-40-0006 und postgresql 6.5.3

I try to retrive some table informations with

  sqlRet = SQLStatistics(
    statment_handle,
    0L, 0,   // All catalogs
    0L, 0,   // All schemas
    (SQLTCHAR *) tableName, strlen(tableName),
    SQL_INDEX_ALL,
    SQL_QUICK ); // table

and get sqlRet == SQL_ERROR (-1)

When I try to get errror information with 

    ret = SQLGetDiagRec( SQL_HANDLE_STMT
                          , statment_handle
                          , 1
                          , Sqlstate
                       ,&NativeError
                          , MessageText
                          , 512
                          ,&TextLengthPtr );

I've got ret == SQL_NO_DATA and no error information :-(


The same statements work with Oracle and M$-Access ODBC-Driver correctly.

Is this feature not supported ?
or do I have to use it in a differnt way ?

Thanks in advance 

Robert