Peter Eisentraut <[email protected]> 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
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
