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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
\! 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
---
Arg is 'dummy'
Arg is '0'
Arg is ''
PLSH_TG_LEVEL=ROW
PLSH_TG_NAME=testtrigger
PLSH_TG_OP=INSERT
PLSH_TG_TABLE_NAME=pfoo
PLSH_TG_TABLE_SCHEMA=public
PLSH_TG_WHEN=AFTER
---
Arg is 'dummy'
Arg is '1'
Arg is 'one'
PLSH_TG_LEVEL=ROW
PLSH_TG_NAME=testtrigger
PLSH_TG_OP=INSERT
PLSH_TG_TABLE_NAME=pfoo
PLSH_TG_TABLE_SCHEMA=public
PLSH_TG_WHEN=AFTER
---
Arg is 'dummy'
Arg is '2'
Arg is 'two'
PLSH_TG_LEVEL=ROW
PLSH_TG_NAME=testtrigger
PLSH_TG_OP=INSERT
PLSH_TG_TABLE_NAME=pfoo
PLSH_TG_TABLE_SCHEMA=public
PLSH_TG_WHEN=AFTER
---
Arg is 'dummy'
Arg is '3'
Arg is 'three'
PLSH_TG_LEVEL=ROW
PLSH_TG_NAME=testtrigger
PLSH_TG_OP=INSERT
PLSH_TG_TABLE_NAME=pfoo
PLSH_TG_TABLE_SCHEMA=public
PLSH_TG_WHEN=AFTER
---
Arg is 'dummy2'
Arg is '1'
Arg is 'one'
PLSH_TG_LEVEL=ROW
PLSH_TG_NAME=testtrigger2
PLSH_TG_OP=UPDATE
PLSH_TG_TABLE_NAME=pfoo
PLSH_TG_TABLE_SCHEMA=public
PLSH_TG_WHEN=BEFORE
---
Arg is 'dummy3'
PLSH_TG_LEVEL=STATEMENT
PLSH_TG_NAME=testtrigger3
PLSH_TG_OP=DELETE
PLSH_TG_TABLE_NAME=pfoo
PLSH_TG_TABLE_SCHEMA=public
PLSH_TG_WHEN=AFTER
---
Arg is 'dummy4'
PLSH_TG_LEVEL=STATEMENT
PLSH_TG_NAME=testtrigger4
PLSH_TG_OP=TRUNCATE
PLSH_TG_TABLE_NAME=pfoo
PLSH_TG_TABLE_SCHEMA=public
PLSH_TG_WHEN=AFTER
\! rm -r /tmp/plsh-test
|
