The following bug has been logged online: Bug reference: 2530 Logged by: Dusan Halicky Email address: [EMAIL PROTECTED] 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