File: event_trigger.sql

package info (click to toggle)
postgresql-plsh 1.20171014-3
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 264 kB
  • sloc: ansic: 562; sql: 136; makefile: 40; sh: 13
file content (26 lines) | stat: -rw-r--r-- 527 bytes parent folder | download | duplicates (6)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
\! mkdir /tmp/plsh-test && chmod a+rwx /tmp/plsh-test

CREATE FUNCTION evttrigger() RETURNS event_trigger AS $$
#!/bin/sh
(
echo "---"
for arg do
    echo "Arg is '$arg'"
done

printenv | LC_ALL=C sort | grep '^PLSH_TG_'
) >> /tmp/plsh-test/bar
chmod a+r /tmp/plsh-test/bar
exit 0
$$ LANGUAGE plsh;

CREATE EVENT TRIGGER testtrigger ON ddl_command_start
    EXECUTE PROCEDURE evttrigger();

CREATE TABLE test (a int, b text);
DROP TABLE test;

DROP EVENT TRIGGER testtrigger;

\! cat /tmp/plsh-test/bar
\! rm -r /tmp/plsh-test