-- Test TRUNCATE with Foreign Keys (on delete triggers)
create table truncate_a (col1 serial primary key);
NOTICE:  CREATE TABLE will create implicit sequence 'truncate_a_col1_seq' for SERIAL column 'truncate_a.col1'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'truncate_a_pkey' for table 'truncate_a'
create table truncate_b (col1 int4 references truncate_a);
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
truncate truncate_a; -- fail
ERROR:  TRUNCATE: Cannot truncate 'truncate_a' with ON DELETE Trigger
truncate truncate_b;
-- Test TRUNCATE with on delete rules
create rule truncate_b_rule as on delete to truncate_b do instead nothing;
truncate truncate_b; -- fail
ERROR:  TRUNCATE: Cannot truncate 'truncate_b' while ON DELETE Rule 'truncate_b_rule' in place