From: | <noreply(at)pgfoundry(dot)org> |
---|---|
To: | noreply(at)pgfoundry(dot)org |
Subject: | [ psqlodbc-Bugs-1000831 ] SQLStatistics ORDINAL_POSITION starts at 2 for PK index |
Date: | 2006-12-12 23:50:52 |
Message-ID: | 20061212235052.BD8B4216E64@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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: Closed
Resolution: None
Priority: 3
Submitted By: Farid Zidan (faridz)
>Assigned to: Hiroshi Inoue (hinoue)
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: Farid Zidan (faridz)
Date: 2006-12-12 15:11
Message:
It's working now. Thanks.
----------------------------------------------------------------------
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
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2006-12-12 23:57:22 | [ psqlodbc-Bugs-1000720 ] SQLGetInfo SQL_DATABASE_NAME no info |
Previous Message | noreply | 2006-12-12 23:50:23 | [ psqlodbc-Bugs-1000836 ] invalid byte sequence for encoding "UTF8": 0x92 |