cartodb-postgresql icon indicating copy to clipboard operation
cartodb-postgresql copied to clipboard

CDB_SyncTable fails with organization user roles

Open jgoizueta opened this issue 6 years ago • 0 comments

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 avatar Jul 02 '19 14:07 jgoizueta