Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- admin_user@54321:ppatests_db=# create sequence wtf;
- CREATE SEQUENCE
- admin_user@54321:ppatests_db=# select
- pg_catalog.pg_sequence_last_value(c.oid::regclass),
- pg_catalog.has_sequence_privilege(c.oid, 'SELECT,USAGE'::text)
- from pg_class c where relname='wtf';
- pg_sequence_last_value | has_sequence_privilege
- ------------------------+------------------------
- | t
- (1 row)
- admin_user@54321:ppatests_db=# select * from wtf;
- last_value | log_cnt | is_called
- ------------+---------+-----------
- 1 | 0 | f
- (1 row)
- /*
- if (pg_class_aclcheck(relid, GetUserId(), ACL_SELECT | ACL_USAGE) != ACLCHECK_OK)
- ereport(ERROR,
- (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
- errmsg("permission denied for sequence %s",
- RelationGetRelationName(seqrel))));
- seq = read_seq_tuple(elm, seqrel, &buf, &seqtuple);
- is_called = seq->is_called;
- result = seq->last_value;
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement