Commit3c505ef

committed

Fill in information schema column for trigger WHEN condition

1 parente6df063 commit3c505efCopy full SHA for 3c505ef

File tree

+13

-4

lines changed

+13

-4

lines changed

Lines changed: 6 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/information_schema.sgml,v 1.42 2009/12/05 21:31:05 petere Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/information_schema.sgml,v 1.43 2009/12/30 22:48:10 petere Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="information-schema">`
`4`	`4`	`<title>The Information Schema</title>`
`@@ -4875,7 +4875,11 @@ ORDER BY c.ordinal_position;`
`4875`	`4875`	`<row>`
`4876`	`4876`	`<entry><literal>action_condition</literal></entry>`
`4877`	`4877`	`<entry><type>character_data</type></entry>`
`4878`		`- <entry>Applies to a feature not available in <productname>PostgreSQL</></entry>`
	`4878`	`+ <entry>`
	`4879`	`+ <literal>WHEN</literal> condition of the trigger, null if none`
	`4880`	`+ (also null if the table is not owned by a currently enabled`
	`4881`	`+ role)`
	`4882`	`+ </entry>`
`4879`	`4883`	`</row>`
`4880`	`4884`
`4881`	`4885`	`<row>`

Lines changed: 7 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -4,7 +4,7 @@`
`4`	`4`	`*`
`5`	`5`	`* Copyright (c) 2003-2009, PostgreSQL Global Development Group`
`6`	`6`	`*`
`7`		`- * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.60 2009/12/07 05:22:21 tgl Exp $`
	`7`	`+ * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.61 2009/12/3022:48:10 petere Exp $`
`8`	`8`	`*/`
`9`	`9`
`10`	`10`	`/*`
`@@ -1909,7 +1909,12 @@ CREATE VIEW triggers AS`
`1909`	`1909`	`CAST(n.nspnameAS sql_identifier)AS event_object_schema,`
`1910`	`1910`	`CAST(c.relnameAS sql_identifier)AS event_object_table,`
`1911`	`1911`	`CAST(nullAS cardinal_number)AS action_order,`
`1912`		`- CAST(nullAS character_data)AS action_condition,`
	`1912`	`+-- XXX strange hacks follow`
	`1913`	`+ CAST(`
	`1914`	`+ CASE WHEN pg_has_role(c.relowner,'USAGE')`
	`1915`	`+ THEN (SELECT m[1]FROM regexp_matches(pg_get_triggerdef(t.oid), E'.{35,} WHEN\$(.+)\$ EXECUTE PROCEDURE')AS rm(m)LIMIT1)`
	`1916`	`+ ELSEnull END`
	`1917`	`+AS character_data)AS action_condition,`
`1913`	`1918`	`CAST(`
`1914`	`1919`	`substring(pg_get_triggerdef(t.oid)from`
`1915`	`1920`	`position('EXECUTE PROCEDURE'insubstring(pg_get_triggerdef(t.oid)from48))+47)`

Comments

(0)