Commit9872812

committed

Sort child tables by name instead of OID in \d+ display

This was an oversight in the recent patch. Found by Tom Lane.

1 parent8fe8ac5 commit9872812Copy full SHA for 9872812

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`* Copyright (c) 2000-2009, PostgreSQL Global Development Group`
`10`	`10`	`*`
`11`		`- * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.221 2009/07/0716:28:38 tgl Exp $`
	`11`	`+ * $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.222 2009/07/0719:05:57 petere Exp $`
`12`	`12`	`*/`
`13`	`13`	`#include"postgres_fe.h"`
`14`	`14`
`@@ -1821,7 +1821,7 @@ describeOneTableDetails(const char *schemaname,`
`1821`	`1821`	`PQclear(result);`
`1822`	`1822`
`1823`	`1823`	`/* print child tables */`
`1824`		`-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);`
	`1824`	`+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);`
`1825`	`1825`
`1826`	`1826`	`result=PSQLexec(buf.data, false);`
`1827`	`1827`	`if (!result)`

Comments

(0)