Re: CVS Commit by dpage: Prevent duplication of - Mailing list pgadmin-hackers

From Andreas Pflug
Subject Re: CVS Commit by dpage: Prevent duplication of
Date
Msg-id 40978FE2.3060703@pse-consulting.de
Whole thread Raw
In response to CVS Commit by dpage: Prevent duplication of functional indexes  (cvs@cvs.pgadmin.org)
List pgadmin-hackers
cvs@cvs.pgadmin.org wrote:

>-        wxT(" ORDER BY cls.relname"));
>+        wxT(" ORDER BY cls.oid, cls.relname"));
>
>

Hi Dave,
did you find out what makes the result duplicate? Maybe the query is
written in a somehow unfortunate way, and could be properly rewritten?

The ORDER BY should probably read ORDER BY cls.relname, cls.oid to
remain alphabetical ordering.

Regards,
Andreas



pgadmin-hackers by date:

Previous
From: cvs@cvs.pgadmin.org
Date:
Subject: CVS Commit by dpage: Prevent duplication of functional indexes
Next
From: cvs@cvs.pgadmin.org
Date:
Subject: CVS Commit by dpage: Fix the sorting of index names I broke earlier.