Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group