Thread: BUG #2530: Some columns not visible when select from table (via odbc only)
BUG #2530: Some columns not visible when select from table (via odbc only)
From
"Dusan Halicky"
Date:
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
Have you tried with another client and ODBC driver? On Jul 13, 2006, at 2:02 PM, Dusan Halicky wrote: > 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 > > ---------------------------(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 > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461