aboutsummaryrefslogtreecommitdiff
path: root/src/test/modules/test_extensions/test_ext_evttrig--1.0.sql
blob: 0071712cb88bf115749e50fdf40e65c491486bfb (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
/* src/test/modules/test_extensions/test_event_trigger--1.0.sql */
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION test_event_trigger" to load this file. \quit

-- Base table with event trigger, used in a regression test involving
-- extension upgrades.
CREATE TABLE t (id text);
CREATE OR REPLACE FUNCTION _evt_table_rewrite_fnct()
RETURNS EVENT_TRIGGER LANGUAGE plpgsql AS
$$
  BEGIN
  END;
$$;
CREATE EVENT TRIGGER table_rewrite_trg
  ON table_rewrite
  EXECUTE PROCEDURE _evt_table_rewrite_fnct();