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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
\! mkdir /tmp/plsh-test && chmod a+rwx /tmp/plsh-test
CREATE FUNCTION shtrigger() RETURNS trigger AS $$
#!/bin/sh
(
echo "---"
for arg do
echo "Arg is '$arg'"
done
printenv | LC_ALL=C sort | grep '^PLSH_TG_'
) >> /tmp/plsh-test/foo
chmod a+r /tmp/plsh-test/foo
exit 0
$$ LANGUAGE plsh;
CREATE TABLE pfoo (a int, b text);
CREATE TRIGGER testtrigger AFTER INSERT ON pfoo
FOR EACH ROW EXECUTE PROCEDURE shtrigger('dummy');
CREATE TRIGGER testtrigger2 BEFORE UPDATE ON pfoo
FOR EACH ROW EXECUTE PROCEDURE shtrigger('dummy2');
CREATE TRIGGER testtrigger3 AFTER DELETE ON pfoo
FOR EACH STATEMENT EXECUTE PROCEDURE shtrigger('dummy3');
CREATE TRIGGER testtrigger4 AFTER TRUNCATE ON pfoo
FOR EACH STATEMENT EXECUTE PROCEDURE shtrigger('dummy4');
INSERT INTO pfoo VALUES (0, null);
INSERT INTO pfoo VALUES (1, 'one');
INSERT INTO pfoo VALUES (2, 'two');
INSERT INTO pfoo VALUES (3, 'three');
UPDATE pfoo SET b = 'oneone' WHERE a = 1;
DELETE FROM pfoo;
TRUNCATE pfoo;
\! cat /tmp/plsh-test/foo
\! rm -r /tmp/plsh-test
|
