blob: fe3d047a41101f7ebaeec66ab6388370dd560189 (
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
28
29
30
|
---
--- CREATE_RULE
---
CREATE RULE rule_1 AS
ON INSERT
TO datatype_table
DO NOTHING;
NOTICE: DDL test: type simple, tag CREATE RULE
CREATE RULE rule_2 AS
ON UPDATE
TO datatype_table
DO INSERT INTO unlogged_table (id) VALUES(NEW.id);
NOTICE: DDL test: type simple, tag CREATE RULE
CREATE RULE rule_3 AS
ON DELETE
TO datatype_table
DO ALSO NOTHING;
NOTICE: DDL test: type simple, tag CREATE RULE
CREATE RULE "_RETURN" AS
ON SELECT
TO like_datatype_table
DO INSTEAD
SELECT * FROM datatype_view;
NOTICE: DDL test: type simple, tag CREATE RULE
CREATE RULE rule_3 AS
ON DELETE
TO like_datatype_table
WHERE id < 100
DO ALSO NOTHING;
NOTICE: DDL test: type simple, tag CREATE RULE
|
