Change to function TZPostgreSQLDatabaseMetadata.GetIndexInfo

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
sandeep_c24
Expert Boarder
Expert Boarder
Posts: 158
Joined: 06.11.2005, 01:43

Change to function TZPostgreSQLDatabaseMetadata.GetIndexInfo

Post by sandeep_c24 »

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
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

Added to svn testing branch.

Mark
sandeep_c24
Expert Boarder
Expert Boarder
Posts: 158
Joined: 06.11.2005, 01:43

Post by sandeep_c24 »

Thanks. BTW what is the svn address of testing branch?

Regards

Sandeep
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

zippo
Silver Boarder
Silver Boarder
Posts: 322
Joined: 12.10.2005, 18:01
Location: Slovenia

Post by zippo »

Offtopic, but anyway: Is there any tutorial for SVN?
Terence
Zeos Dev Team
Zeos Dev Team
Posts: 141
Joined: 22.09.2005, 14:11
Location: Stuttgart
Contact:

Post by Terence »

fabian
Post Reply