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

[ psqlodbc-Bugs-1000620 ] SQLStatistics returns UNKNOWN instead of real column names

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000620 ] SQLStatistics returns UNKNOWN instead of real column names
Date: 2006-04-27 03:44:47
Message-ID: 20060427034447.EA03C86C4D6@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Bugs item #1000620, was opened at 2006-04-26 17:24
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000620&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: SQLStatistics returns UNKNOWN instead of real column names

Initial Comment:
Created By: 	den <NOSPAM> intech.ru
Description:

    STEPS TO REPRODUCE
    1. CREATE TABLE temp_table (a int)
    2. ALTER TABLE temp_table DROP COLUMN a
    3. ALTER TABLE temp_table ADD COLUMN a int
    4. CREATE INDEX temp_index ON temp_table (a)

    CAUSE OF FAILURE
    Source code has a petty hole based on the erroneous interpretation of the
    column index stored in the pg_index.indkey. In this case the column index is
    not a sequence number of column, but value of the pg_attribute.attnum.

    Listing of source code: info.c (psqlodbc-08.00.0102)
    ....
    2824 if (fields_vector[i] == OID_ATTNUM)
    2825 {
    2826 set_tuplefield_string(&row->tuple[8], "oid");
    2827 mylog("%s: column name = oid\n", func);
    2828 }
    ->2829 else if (fields_vector[i] < 0 || fields_vector[i] > total_columns)
    2830 {
    2831 set_tuplefield_string(&row->tuple[8], "UNKNOWN");
    2832 mylog("%s: column name = UNKNOWN\n", func);
    2833 }
    2834 else
    2835 {
    ->2836 set_tuplefield_string(&row->tuple[8],
    column_names[fields_vector[i] - 1]);
    2837 mylog("%s: column name = '%s'\n", func,
    column_names[fields_vector[i] - 1]);
    2838 }
    ...

----------------------------------------------------------------------

>Comment By: Hiroshi Inoue (hinoue)
Date: 2006-04-27 03:44

Message:
Please try the experimental version.
Please download it from this page and replace
 the dll(psqlodbc35w.dll) by the one at
 http://www.geocities.jp/inocchichichi/psqlodbc/index.html
.

regards,
Hiroshi Inoue

----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000620&group_id=1000125

pgsql-odbc by date

Next:From: Antonio PenninoDate: 2006-04-27 08:00:08
Subject: Pocket PC
Previous:From: P.MODate: 2006-04-26 20:48:54
Subject: Re: Problem with the PGSQL-ODBC driver and MS Access

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