blob: 2d56eaa44cd46d451d993ec8474e67781a6da15e (
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
|
\set VERBOSITY 'terse'
set client_min_messages = 'warning';
-- test sqltriga truncate
create table trunctrg1 (
dat1 text not null primary key,
dat2 int2 not null,
dat3 text
);
create trigger trunc1_trig after truncate on trunctrg1
for each statement execute procedure pgq.sqltriga('que3');
truncate trunctrg1;
WARNING: insert_event(que3, R, , public.trunctrg1)
-- test logutriga truncate
create table trunctrg2 (
dat1 text not null primary key,
dat2 int2 not null,
dat3 text
);
create trigger trunc2_trig after truncate on trunctrg2
for each statement execute procedure pgq.logutriga('que3');
truncate trunctrg2;
WARNING: insert_event(que3, R, , public.trunctrg2)
-- test deny
create trigger deny_triga2 after truncate on trunctrg2
for each statement execute procedure pgq.logutriga('noqueue', 'deny');
truncate trunctrg2;
ERROR: Table 'public.trunctrg2' to queue 'noqueue': change not allowed (R)
|
