Commit3bae43c

committed

Sort default partition to bottom of psql \d+

Minor patch to change sort order onlyAuthor: Ashutosh BapatReviewed-by: Álvaro Herrera, Simon Riggs

1 parent05b6ec3 commit3bae43cCopy full SHA for 3bae43c

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2875,7 +2875,8 @@ describeOneTableDetails(const char *schemaname,`
`2875`	`2875`	`" c.relkind"`
`2876`	`2876`	`" FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i"`
`2877`	`2877`	`" WHERE c.oid=i.inhrelid AND i.inhparent = '%s'"`
`2878`		`-" ORDER BY c.oid::pg_catalog.regclass::pg_catalog.text;",oid);`
	`2878`	`+" ORDER BY pg_catalog.pg_get_expr(c.relpartbound, c.oid) = 'DEFAULT',"`
	`2879`	`+" c.oid::pg_catalog.regclass::pg_catalog.text;",oid);`
`2879`	`2880`	`elseif (pset.sversion >=80300)`
`2880`	`2881`	`printfPQExpBuffer(&buf,`
`2881`	`2882`	`"SELECT c.oid::pg_catalog.regclass"`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -436,11 +436,11 @@ from hash_parted order by part;`
`436`	`436`	`Partition key: LIST (lower(a))`
`437`	`437`	`Partitions: part_aa_bb FOR VALUES IN ('aa', 'bb'),`
`438`	`438`	`part_cc_dd FOR VALUES IN ('cc', 'dd'),`
`439`		`- part_default DEFAULT, PARTITIONED,`
`440`	`439`	`part_ee_ff FOR VALUES IN ('ee', 'ff'), PARTITIONED,`
`441`	`440`	`part_gg FOR VALUES IN ('gg'), PARTITIONED,`
`442`	`441`	`part_null FOR VALUES IN (NULL),`
`443`		`- part_xx_yy FOR VALUES IN ('xx', 'yy'), PARTITIONED`
	`442`	`+ part_xx_yy FOR VALUES IN ('xx', 'yy'), PARTITIONED,`
	`443`	`+ part_default DEFAULT, PARTITIONED`
`444`	`444`
`445`	`445`	`-- cleanup`
`446`	`446`	`drop table range_parted, list_parted;`

Comments

(0)