Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

permission denied for relation pg_authid #2

Closed
colttt opened this issue May 6, 2015 · 1 comment
Closed

permission denied for relation pg_authid #2

colttt opened this issue May 6, 2015 · 1 comment

Comments

@colttt
Copy link

colttt commented May 6, 2015

Hello,

when i look to my database-log and i see a lot of errors like:

`2015-04-14 06:34:51 CEST STATEMENT: SELECT t.oid, t.spcname, a.rolname from pg_tablespace t JOIN pg_authid a ON a.oid = t.spcowner
2015-04-14 06:40:51 CEST ERROR: permission denied for relation pg_authid

why you need access to pg_authid?

@cavaliercoder
Copy link
Collaborator

The next version will use pg_roles instead of the legacy pg_authid but this is used to get the name of the owner of a relation. Most relations store the ID of the owner, but not the owner's friendly name.

I'll close this in lieu of issue #4 which will fix this issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants