The following bug has been logged online:

Bug reference: 2530
Logged by: Dusan Halicky
Email address: dvh.tosomja (AT) post (DOT) 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

---------------------------(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

Have you tried with another client and ODBC driver?

On Jul 13, 2006, at 2:02 PM, Dusan Halicky wrote:
--
Jim C. Nasby, Sr. Engineering Consultant jnasby (AT) pervasive (DOT) com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq