I think line no 2778 in unit ZDbcPostgreSqlMetadata should be like this
SQL := SQL + ' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION ';
I have added ORDINAL_POSITION in order by clause. If this will not break any code could this be included in the next release. This fix is required by InstantObjects and I think it is also correct to get the IndexFields for an Index in this order.
Regards
Sandeep
Change to function TZPostgreSQLDatabaseMetadata.GetIndexInfo
Moderators: gto, cipto_kh, EgonHugeist
-
- Expert Boarder
- Posts: 158
- Joined: 06.11.2005, 01:43
-
- Expert Boarder
- Posts: 158
- Joined: 06.11.2005, 01:43