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 table projects #1227

Open
Abenstex opened this issue Dec 8, 2023 · 1 comment
Open

Permission denied for table projects #1227

Abenstex opened this issue Dec 8, 2023 · 1 comment

Comments

@Abenstex
Copy link

Abenstex commented Dec 8, 2023

Hi all,

I tried executing the following statement (using a docker image):
SELECT * FROM pgml.train( project_name => 'Document ranking based on number of clicks', task => 'regression', relation_name => 'document_viewed_counter', y_column_name => 'click_count' );
However, I received the following error: ERROR: permission denied for table projects. What am I missing?

@montanalow
Copy link
Contributor

Is this in the cloud, docker or a different database? It's likely the connection you're using is not a database superuser, and the pgml.projects table was created by a different user.

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