From: | "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Severe bug in SQLPrimaryKeys function in psqlODBC 09.06.0500 |
Date: | 2017-09-28 10:05:52 |
Message-ID: | trinity-3b41d1e9-5a91-42c0-9b60-d4545fd3af3a-1506593152458@3c-app-gmx-bs45 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello,
there seems to be a new bug in the SQLPrimaryKeys function - e.g. called with (042C0FB0, , 0, , 0, table, -3).
It generates this SELECT:
select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'table' AND n.nspname = E'xxx' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnumselect ta.attname, ia.attnum, ic.relname, n.nspname, NULL from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class ic, pg_catalog.pg_index i, pg_catalog.pg_namespace n where ic.relname = E'ktom_pkey' AND n.nspname = E'mbs' AND ic.oid = i.indexrelid AND n.oid = ic.relnamespace AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) order by ia.attnum
In 09.06.0410 everything is okay.
I have the psqlODBC logs in case you need them.
Best regards,
Peter
From | Date | Subject | |
---|---|---|---|
Next Message | Jan-Peter Seifert | 2017-09-28 12:42:04 | Re: Severe bug in SQLPrimaryKeys function in psqlODBC 09.06.0500 |
Previous Message | Inoue, Hiroshi | 2017-09-21 04:05:56 | Re: Error Notification |