[PATCHES] Error in ORDER BY on check constraints in psql

2005-10-19 Thread Christopher Kings-Lynne
Everything is sorted by object name in \d table except check constraints for some reason. It seems it's ordering by the wrong column. Seems like a bug to me. Attached is the trivial patch. Chris Index: src/bin/psql/describe.c

Re: [PATCHES] Error in ORDER BY on check constraints in psql

2005-10-19 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: Everything is sorted by object name in \d table except check constraints for some reason. It seems it's ordering by the wrong column. Seems like a bug to me. That was probably done deliberately, back in the day when constraints tended to have

Re: [PATCHES] Error in ORDER BY on check constraints in psql

2005-10-19 Thread Christopher Kings-Lynne
That was probably done deliberately, back in the day when constraints tended to have uselessly random names like $1 --- sorting by the constraint text was more helpful. I agree that now sorting by name seems like the better thing. Even in the $x case, it's better to have them sorted in that