Re: Have \d show child tables that inherit from the specified parent - Mailing list pgsql-hackers

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