Re: [HACKERS] sequence privileges in information schema

2011-04-26 Thread Tom Lane
Peter Eisentraut writes: > We currently don't represent the sequence privileges in the information > schema. We could perhaps do a subset of them. > In the SQL standard, there is only the USAGE privilege, and its only > purpose (AFAICT) is to allow the NEXT VALUE FOR expression. > PostgreSQL's n

[HACKERS] sequence privileges in information schema

2011-04-26 Thread Peter Eisentraut
We currently don't represent the sequence privileges in the information schema. We could perhaps do a subset of them. In the SQL standard, there is only the USAGE privilege, and its only purpose (AFAICT) is to allow the NEXT VALUE FOR expression. PostgreSQL's nextval(), by contrast, requires both