Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes14kdownloads

rootpgsqlshareextensiontest_ext_evttrig--1.0.sql

test_ext_evttrig--1.0.sql17 linesDownload Raw Back to extension

1/* src/test/modules/test_extensions/test_event_trigger--1.0.sql */2-- complain if script is sourced in psql, rather than via CREATE EXTENSION3\echo Use "CREATE EXTENSION test_event_trigger" to load this file. \quit4 5-- Base table with event trigger, used in a regression test involving6-- extension upgrades.7CREATE TABLE t (id text);8CREATE OR REPLACE FUNCTION _evt_table_rewrite_fnct()9RETURNS EVENT_TRIGGER LANGUAGE plpgsql AS10$$11  BEGIN12  END;13$$;14CREATE EVENT TRIGGER table_rewrite_trg15  ON table_rewrite16  EXECUTE PROCEDURE _evt_table_rewrite_fnct();17