Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2019
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. admin_user@54321:ppatests_db=# create sequence wtf;
  2. CREATE SEQUENCE
  3.  
  4. admin_user@54321:ppatests_db=# select
  5. pg_catalog.pg_sequence_last_value(c.oid::regclass),
  6. pg_catalog.has_sequence_privilege(c.oid, 'SELECT,USAGE'::text)
  7. from pg_class c where relname='wtf';
  8. pg_sequence_last_value | has_sequence_privilege
  9. ------------------------+------------------------
  10. | t
  11. (1 row)
  12.  
  13. admin_user@54321:ppatests_db=# select * from wtf;
  14. last_value | log_cnt | is_called
  15. ------------+---------+-----------
  16. 1 | 0 | f
  17. (1 row)
  18.  
  19. /*
  20. if (pg_class_aclcheck(relid, GetUserId(), ACL_SELECT | ACL_USAGE) != ACLCHECK_OK)
  21. ereport(ERROR,
  22. (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
  23. errmsg("permission denied for sequence %s",
  24. RelationGetRelationName(seqrel))));
  25.  
  26. seq = read_seq_tuple(elm, seqrel, &buf, &seqtuple);
  27.  
  28. is_called = seq->is_called;
  29. result = seq->last_value;
  30. */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement