Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- transcript=# drop table tr_config;
- DROP TABLE
- transcript=# CREATE TABLE public.tr_config
- transcript-# (
- transcript(# retention_period integer DEFAULT 90,
- transcript(# num_of_cpus integer DEFAULT NULL CHECK (num_of_cpus > 1)
- transcript(# );
- CREATE TABLE
- transcript=#
- transcript=# select update_triggered_table('tr_config');
- NOTICE: trigger "modify_tr_config" for relation "public.tr_config" does not exist, skipping
- update_triggered_table
- ------------------------
- (1 row)
- transcript=#
- transcript=#
- transcript=#
- transcript=#
- transcript=# select * from tr_config;
- retention_period | num_of_cpus
- ------------------+-------------
- (0 rows)
- transcript=#
- transcript=#
- transcript=#
- transcript=# update tr_config set num_of_cpus=4 where 1=1;
- UPDATE 0
- transcript=# select * from tr_config;
- retention_period | num_of_cpus
- ------------------+-------------
- (0 rows)
- transcript=#
- transcript=#
- transcript=#
- transcript=# insert into tr_config (num_of_cpus) values (4);
- INSERT 0 0
- transcript=# select * from tr_config;
- retention_period | num_of_cpus
- ------------------+-------------
- (0 rows)
- transcript=# delete from tr_config where 1=1;
- DELETE 0
- transcript=# select * from tr_config;
- retention_period | num_of_cpus
- ------------------+-------------
- (0 rows)
- transcript=#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement