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
27
|
\! 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
---
PLSH_TG_EVENT=ddl_command_start
PLSH_TG_TAG=CREATE TABLE
---
PLSH_TG_EVENT=ddl_command_start
PLSH_TG_TAG=DROP TABLE
\! rm -r /tmp/plsh-test
|
