Commit8936867

committed

Add prosecdef to \df+ output.

Jon Erdman, reviewed by Phil Sorber and Stephen Frost.

1 parent7441b49 commit8936867Copy full SHA for 8936867

File tree

-3

lines changed

-3

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1188,7 +1188,7 @@ testdb=>`
`1188`	`1188`	`class="parameter">pattern</replaceable> is specified, only`
`1189`	`1189`	`functions whose names match the pattern are shown. If the`
`1190`	`1190`	`form <literal>\df+</literal> is used, additional information`
`1191`		`- about each function, including volatility, language, source`
	`1191`	`+ about each function, includingsecurity,volatility, language, source`
`1192`	`1192`	`code and description, is shown. By default, only user-created`
`1193`	`1193`	`objects are shown; supply a pattern or the <literal>S</literal>`
`1194`	`1194`	`modifier to include system objects.`

Lines changed: 6 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -256,7 +256,7 @@ describeFunctions(const char functypes, const char pattern, bool verbose, bool`
`256`	`256`	`" WHEN p.proiswindow THEN '%s'\n"`
`257`	`257`	`" WHEN p.prorettype = 'pg_catalog.trigger'::pg_catalog.regtype THEN '%s'\n"`
`258`	`258`	`" ELSE '%s'\n"`
`259`		`-"END as \"%s\"",`
	`259`	`+"END as \"%s\"",`
`260`	`260`	`gettext_noop("Result data type"),`
`261`	`261`	`gettext_noop("Argument data types"),`
`262`	`262`	`/* translator: "agg" is short for "aggregate" */`
`@@ -330,15 +330,19 @@ describeFunctions(const char functypes, const char pattern, bool verbose, bool`
`330`	`330`
`331`	`331`	`if (verbose)`
`332`	`332`	`appendPQExpBuffer(&buf,`
	`333`	`+",\n CASE WHEN prosecdef THEN '%s' ELSE '%s' END AS \"%s\""`
`333`	`334`	`",\n CASE\n"`
`334`	`335`	`" WHEN p.provolatile = 'i' THEN '%s'\n"`
`335`	`336`	`" WHEN p.provolatile = 's' THEN '%s'\n"`
`336`	`337`	`" WHEN p.provolatile = 'v' THEN '%s'\n"`
`337`		`-"END as \"%s\""`
	`338`	`+"END as \"%s\""`
`338`	`339`	`",\n pg_catalog.pg_get_userbyid(p.proowner) as \"%s\",\n"`
`339`	`340`	`" l.lanname as \"%s\",\n"`
`340`	`341`	`" p.prosrc as \"%s\",\n"`
`341`	`342`	`" pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"",`
	`343`	`+gettext_noop("definer"),`
	`344`	`+gettext_noop("invoker"),`
	`345`	`+gettext_noop("Security"),`
`342`	`346`	`gettext_noop("immutable"),`
`343`	`347`	`gettext_noop("stable"),`
`344`	`348`	`gettext_noop("volatile"),`

Comments

(0)