BUG #2530: Some columns not visible when select from table (via odbc only)

From: "Dusan Halicky" <dvh(dot)tosomja(at)post(dot)sk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2530: Some columns not visible when select from table (via odbc only)
Date: 2006-07-13 14:02:27
Message-ID: 200607131402.k6DE2RYZ056219@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2530
Logged by: Dusan Halicky
Email address: dvh(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nikolay Samokhvalov 2006-07-13 14:15:39 Strange behaviour of RULE (selecting last inserted ID of 'sequenced' column)
Previous Message Gosia 2006-07-13 08:35:28 BUG #2529: it doesn't start- the log files are not found