Peter Eisentraut <peter_e@gmx.net> writes:
> On Tuesday 07 July 2009 19:35:54 Tom Lane wrote:
>> I looked at this patch. I'm a bit disturbed by the
>> ORDER BY c.oid::pg_catalog.regclass
>> business. I doubt that does what the author thinks, and I'm not sure
>> what we really want anyway. If we want the child table names sorted
>> alphabetically then the regclass value needs to be further cast to text,
>> ie
>> ORDER BY c.oid::pg_catalog.regclass::pg_catalog.text
> Fixed; it was clearly meant to be by name.
Testing shows that we still have a problem: the query now fails outright
with pre-8.3 servers:
regression=# \d+ a
ERROR: cannot cast type regclass to text
Perhaps it would be sufficient to ORDER BY c.relname.
regards, tom lane