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

CDB_SyncTable fails with organization user roles #366

Open
jgoizueta opened this issue Jul 2, 2019 · 0 comments
Open

CDB_SyncTable fails with organization user roles #366

jgoizueta opened this issue Jul 2, 2019 · 0 comments
Assignees
Labels

Comments

@jgoizueta
Copy link
Contributor

jgoizueta commented Jul 2, 2019

The user roles of org members are not allowed to create temporary tables:

PG::InsufficientPrivilege:
ERROR:  permission denied to create temporary tables in database "cartodb_user_xxxxxxxxxxx_db"
LINE 1: CREATE TEMP TABLE src_sync_511175814_65060(cartodb_id BIGINT...
                          ^
QUERY:  CREATE TEMP TABLE src_sync_511175814_65060(cartodb_id BIGINT, hash TEXT) ON COMMIT DROP
CONTEXT:  PL/pgSQL function cdb_synctable(regclass,regnamespace,name,name[]) line 36 at EXECUTE

A possible solution for this would be to avoid temporary table creation as in #365

cc @rafatower

@jgoizueta jgoizueta added the bug label Jul 2, 2019
@jgoizueta jgoizueta self-assigned this Jul 2, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant