Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2020
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. transcript=# drop table tr_config;
  2. DROP TABLE
  3. transcript=# CREATE TABLE public.tr_config
  4. transcript-# (
  5. transcript(# retention_period integer DEFAULT 90,
  6. transcript(# num_of_cpus integer DEFAULT NULL CHECK (num_of_cpus > 1)
  7. transcript(# );
  8. CREATE TABLE
  9. transcript=#
  10. transcript=# select update_triggered_table('tr_config');
  11. NOTICE: trigger "modify_tr_config" for relation "public.tr_config" does not exist, skipping
  12. update_triggered_table
  13. ------------------------
  14.  
  15. (1 row)
  16.  
  17. transcript=#
  18. transcript=#
  19. transcript=#
  20. transcript=#
  21. transcript=# select * from tr_config;
  22. retention_period | num_of_cpus
  23. ------------------+-------------
  24. (0 rows)
  25.  
  26. transcript=#
  27. transcript=#
  28. transcript=#
  29. transcript=# update tr_config set num_of_cpus=4 where 1=1;
  30. UPDATE 0
  31. transcript=# select * from tr_config;
  32. retention_period | num_of_cpus
  33. ------------------+-------------
  34. (0 rows)
  35.  
  36. transcript=#
  37. transcript=#
  38. transcript=#
  39. transcript=# insert into tr_config (num_of_cpus) values (4);
  40. INSERT 0 0
  41. transcript=# select * from tr_config;
  42. retention_period | num_of_cpus
  43. ------------------+-------------
  44. (0 rows)
  45.  
  46. transcript=# delete from tr_config where 1=1;
  47. DELETE 0
  48. transcript=# select * from tr_config;
  49. retention_period | num_of_cpus
  50. ------------------+-------------
  51. (0 rows)
  52.  
  53. transcript=#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement