blob: 7d03859a172fc6223d4852e846e8583167889bb2 (
plain)
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
|
---
--- CREATE_RULE
---
--- Note: views' ON SELECT rules are tested elsewhere.
---
CREATE RULE rule_1 AS
ON INSERT
TO datatype_table
DO NOTHING;
CREATE RULE rule_2 AS
ON UPDATE
TO datatype_table
DO INSERT INTO unlogged_table (id) VALUES(NEW.id);
CREATE RULE rule_3 AS
ON DELETE
TO datatype_table
DO ALSO NOTHING;
CREATE RULE rule_3 AS
ON DELETE
TO like_datatype_table
WHERE id < 100
DO ALSO NOTHING;
|
