BUG #2530: Some columns not visible when select from table (via odbc only) - Mailing list pgsql-bugs

From Dusan Halicky
Subject BUG #2530: Some columns not visible when select from table (via odbc only)
Date
Msg-id 200607131402.k6DE2RYZ056219@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #2530: Some columns not visible when select from table (via odbc only)  (Jim Nasby <jnasby@pervasive.com>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      2530
Logged by:          Dusan Halicky
Email address:      dvh.tosomja@post.sk
PostgreSQL version: 8.1.4-1
Operating system:   Windows XP
Description:        Some columns not visible when select from table (via
odbc only)
Details:

I create this table:

create table foo (aaa serial, bbb integer, ccc char(20));

insert into foo values (1, 24, 'John');

And when i make select (in SQL Explorer which use ODBC), there is only first
2 columns:

select * from foo;

aaa bbb
1   24

The same select in psql give me correct results:

aaa bbb ccc
1   24  John

The odbc is psqlODBC 08.02.0002, advanced options in odbc administrator
(screenshots) is stored here:

http://senzory.ahoj.sk/pg/index.html

pgsql-bugs by date:

Previous
From: Wang Haiyong
Date:
Subject: pg_restore parameter( -n) not work
Next
From: Tom Lane
Date:
Subject: Re: pg_restore parameter( -n) not work