[ psqlodbc-Bugs-1000831 ] SQLStatistics ORDINAL_POSITION starts at 2 for PK index

Bugs item #1000831, was opened at 2006-12-10 20:42
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000831&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Farid Zidan (faridz)
Assigned to: Nobody (None)
Summary: SQLStatistics ORDINAL_POSITION starts at 2 for PK index

Initial Comment:
Example,

create table in_sync_rs_type (
rs_type_cd           CHAR(8)              not null,
rs_type_desc         VARCHAR(30)          not null,
object_ind           INT2                 not null,
object_pattern_ind   INT2                 not null,
ctrl_ins_dtm         TIMESTAMP            not null default CURRENT_TIMESTAMP,
ctrl_upd_dtm         TIMESTAMP            not null,
ctrl_usr_id          VARCHAR(128)         not null,
constraint PK_IN_SYNC_RS_TYPE primary key (rs_type_cd)
);


SQLStatistics returns ordinal_position for PK_IN_SYNC_RS_TYPE column rs_type_cd as 2 instead of 1

Driver PostgreSQL ANSI 8.02.02.00 and 8.02.02.03


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

>Comment By: Hiroshi Inoue (hinoue)
Date: 2006-12-11 00:31

Message:
The bug seems to be caused by the recent change.
Please try the attached dll.

regards,
Hiroshi Inoue

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

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