Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2019
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. pagila=> select last_value from actor_actor_id_seq;
  2. ERROR: permission denied for sequence actor_actor_id_seq
  3.  
  4. pagila=> select case when false then (select last_value from actor_actor_id_seq) else null end;
  5. case
  6. ------
  7.  
  8. (1 row)
  9.  
  10. pagila=> select pg_catalog.has_sequence_privilege('actor_actor_id_seq'::regclass,'SELECT,USAGE'::text); has_sequence_privilege
  11. ------------------------
  12. f
  13. (1 row)
  14.  
  15. pagila=> select case when pg_catalog.has_sequence_privilege('actor_actor_id_seq'::regclass,'SELECT,USAGE'::text) then (select last_value from actor_actor_id_seq) else null end;
  16. ERROR: permission denied for sequence actor_actor_id_seq
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement