diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2009-07-07 19:05:57 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2009-07-07 19:05:57 +0000 |
| commit | 987281274f7257c1fe3304309f0ba3f39e96532f (patch) | |
| tree | 5b047082c5cb601819029972090cf5e58b044320 | |
| parent | 8fe8ac5f40c9002cb48657dd77c7d85de470af6f (diff) | |
| download | postgresql-987281274f7257c1fe3304309f0ba3f39e96532f.tar.gz postgresql-987281274f7257c1fe3304309f0ba3f39e96532f.zip | |
Sort child tables by name instead of OID in \d+ display
This was an oversight in the recent patch. Found by Tom Lane.
| -rw-r--r-- | src/bin/psql/describe.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index be864780a64..80b4bd5e9d7 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -8,7 +8,7 @@ * * Copyright (c) 2000-2009, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.221 2009/07/07 16:28:38 tgl Exp $ + * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.222 2009/07/07 19:05:57 petere Exp $ */ #include "postgres_fe.h" @@ -1821,7 +1821,7 @@ describeOneTableDetails(const char *schemaname, PQclear(result); /* print child tables */ - printfPQExpBuffer(&buf, "SELECT c.oid::pg_catalog.regclass FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i WHERE c.oid=i.inhrelid AND i.inhparent = '%s' ORDER BY c.oid::pg_catalog.regclass;", oid); + printfPQExpBuffer(&buf, "SELECT c.oid::pg_catalog.regclass FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i WHERE c.oid=i.inhrelid AND i.inhparent = '%s' ORDER BY c.oid::pg_catalog.regclass::text;", oid); result = PSQLexec(buf.data, false); if (!result) |