Skip to content
This repository was archived by the owner on Jan 5, 2026. It is now read-only.
This repository was archived by the owner on Jan 5, 2026. It is now read-only.

CDB_SyncTable fails with organization user roles #366

@jgoizueta

Description

@jgoizueta

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

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions