NotificationsYou must be signed in to change notification settings
Fork28
Star151

Commit3855968

committed

Syntax support and documentation for event triggers.

They don't actually do anything yet; that will get fixed in afollow-on commit. But this gets the basic infrastructure in place,including CREATE/ALTER/DROP EVENT TRIGGER; support for COMMENT,SECURITY LABEL, and ALTER EXTENSION .. ADD/DROP EVENT TRIGGER;pg_dump and psql support; and documentation for the anticipatedinitial feature set.Dimitri Fontaine, with review and a bunch of additional hacking by me.Thom Brown extensively reviewed earlier versions of this patch set,but there's not a whole lot of that code left in this commit, as itturns out.

1 parentfaf26bf commit3855968Copy full SHA for 3855968

File tree

56 files changed

+2398

-18

lines changed

doc/src/sgml
src
- backend
  - catalog
  - commands
  - nodes
    - copyfuncs.c
    - equalfuncs.c
  - parser
    - gram.y
  - tcop
    - utility.c
  - utils
    - adt
      - pseudotypes.c
    - cache
      - syscache.c
- bin
  - pg_dump
  - psql
- include
  - catalog
  - commands
    - event_trigger.h
  - nodes
    - nodes.h
    - parsenodes.h
  - parser
    - kwlist.h
  - utils
- test/regress
  - expected
  - parallel_schedule
  - serial_schedule
  - sql
    - event_trigger.sql

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

56 files changed

+2398

-18

lines changed

`‎doc/src/sgml/catalogs.sgml`

Lines changed: 87 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -143,6 +143,11 @@`
`143`	`143`	`<entry>enum label and value definitions</entry>`
`144`	`144`	`</row>`
`145`	`145`
	`146`	`+ <row>`
	`147`	`+ <entry><link linkend="catalog-pg-event-trigger"><structname>pg_event_trigger</structname></link></entry>`
	`148`	`+ <entry>event triggers</entry>`
	`149`	`+ </row>`
	`150`	`+`
`146`	`151`	`<row>`
`147`	`152`	`<entry><link linkend="catalog-pg-extension"><structname>pg_extension</structname></link></entry>`
`148`	`153`	`<entry>installed extensions</entry>`
`@@ -1857,6 +1862,88 @@`
`1857`	`1862`	`</para>`
`1858`	`1863`	`</sect1>`
`1859`	`1864`
	`1865`	`+ <sect1 id="catalog-pg-event-trigger">`
	`1866`	`+ <title><structname>pg_event_trigger</structname></title>`
	`1867`	`+`
	`1868`	`+ <indexterm zone="catalog-pg-event-trigger">`
	`1869`	`+ <primary>pg_event_trigger</primary>`
	`1870`	`+ </indexterm>`
	`1871`	`+`
	`1872`	`+ <para>`
	`1873`	`+ The catalog <structname>pg_event_trigger</structname> stores event triggers.`
	`1874`	`+ See <xref linkend="event-triggers"> for more information.`
	`1875`	`+ </para>`
	`1876`	`+`
	`1877`	`+ <table>`
	`1878`	`+ <title><structname>pg_event_trigger</> Columns</title>`
	`1879`	`+`
	`1880`	`+ <tgroup cols="4">`
	`1881`	`+ <thead>`
	`1882`	`+ <row>`
	`1883`	`+ <entry>Name</entry>`
	`1884`	`+ <entry>Type</entry>`
	`1885`	`+ <entry>References</entry>`
	`1886`	`+ <entry>Description</entry>`
	`1887`	`+ </row>`
	`1888`	`+ </thead>`
	`1889`	`+`
	`1890`	`+ <tbody>`
	`1891`	`+ <row>`
	`1892`	`+ <entry><structfield>evtname</structfield></entry>`
	`1893`	`+ <entry><type>name</type></entry>`
	`1894`	`+ <entry></entry>`
	`1895`	`+ <entry>Trigger name (must be unique)</entry>`
	`1896`	`+ </row>`
	`1897`	`+`
	`1898`	`+ <row>`
	`1899`	`+ <entry><structfield>evtevent</structfield></entry>`
	`1900`	`+ <entry><type>name</type></entry>`
	`1901`	`+ <entry></entry>`
	`1902`	`+ <entry>Identifies the event for which this trigger fires</entry>`
	`1903`	`+ </row>`
	`1904`	`+`
	`1905`	`+ <row>`
	`1906`	`+ <entry><structfield>evtowner</structfield></entry>`
	`1907`	`+ <entry><type>oid</type></entry>`
	`1908`	`+ <entry><literal><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link>.oid</literal></entry>`
	`1909`	`+ <entry>Owner of the event trigger</entry>`
	`1910`	`+ </row>`
	`1911`	`+`
	`1912`	`+ <row>`
	`1913`	`+ <entry><structfield>evtfoid</structfield></entry>`
	`1914`	`+ <entry><type>oid</type></entry>`
	`1915`	`+ <entry><literal><link linkend="catalog-pg-proc"><structname>pg_proc</structname></link>.oid</literal></entry>`
	`1916`	`+ <entry>The function to be called</entry>`
	`1917`	`+ </row>`
	`1918`	`+`
	`1919`	`+ <row>`
	`1920`	`+ <entry><structfield>evtenabled</structfield></entry>`
	`1921`	`+ <entry><type>char</type></entry>`
	`1922`	`+ <entry></entry>`
	`1923`	`+ <entry>`
	`1924`	`+ Controls in which <xref linkend="guc-session-replication-role"> modes`
	`1925`	`+ the event trigger fires.`
	`1926`	`+ <literal>O</> = trigger fires in <quote>origin</> and <quote>local</> modes,`
	`1927`	`+ <literal>D</> = trigger is disabled,`
	`1928`	`+ <literal>R</> = trigger fires in <quote>replica</> mode,`
	`1929`	`+ <literal>A</> = trigger fires always.`
	`1930`	`+ </entry>`
	`1931`	`+ </row>`
	`1932`	`+`
	`1933`	`+ <row>`
	`1934`	`+ <entry><structfield>evttags</structfield></entry>`
	`1935`	`+ <entry><type>text[]</type></entry>`
	`1936`	`+ <entry></entry>`
	`1937`	`+ <entry>`
	`1938`	`+ Command tags for which this trigger will fire. If NULL, the firing`
	`1939`	`+ of this trigger is not restricted on the basis of the command tag.`
	`1940`	`+ </entry>`
	`1941`	`+ </row>`
	`1942`	`+ </tbody>`
	`1943`	`+ </tgroup>`
	`1944`	`+ </table>`
	`1945`	`+ </sect1>`
	`1946`	`+`
`1860`	`1947`	`<sect1 id="catalog-pg-constraint">`
`1861`	`1948`	`<title><structname>pg_constraint</structname></title>`
`1862`	`1949`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit3855968

File tree

56 files changed

Some content is hidden

56 files changed

`‎doc/src/sgml/catalogs.sgml`

0 commit comments