BUG #12897: SQLDescribeColumn() and bit columns - Mailing list pgsql-bugs

From smarvin@pobox.com
Subject BUG #12897: SQLDescribeColumn() and bit columns
Date
Msg-id 20150325140522.2562.7220@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12897
Logged by:          Steve Marvin
Email address:      smarvin@pobox.com
PostgreSQL version: 9.4.1
Operating system:   Windows 8.1
Description:

when using statement 'select btest from public.tblname limit 1',
SQLDescribeColumn(1,...) returns nSQLType of 12 (SQL_VARCHAR) and length of
255 on columns of type 'bit' instead of -7(SQL_BIT) and length of 1.
select * from information_schema.columns using tablename,columnname,catalog
shows
the data_type is 'bit' and all other column information is correct.
ODBC Driver is PostgreSQL ANSI 9.03.04.00 10/26/2014.
Tested both x86 and x64 drivers.

pgsql-bugs by date:

Previous
From: Jaimin Pan
Date:
Subject: [Report Bug With Patch] Rel Cache Bug
Next
From: jgpedro@gmail.com
Date:
Subject: BUG #12898: Failure loading materialized view with pg_restore