Sample Header Ad - 728x90

PostgreSQL Citus Extension Temp Table

5 votes
2 answers
685 views
Is it possible with citus extension in PostgreSQL to create temp table that is copied to each worker node (like reference table)? When I run SQL like this: DROP TABLE IF EXISTS mypoint; CREATE TEMP TABLE mypoint (mpoint geometry primary key); SELECT create_reference_table('mypoint'); I get the error: > ERROR: unacceptable schema name "pg_temp_6" > DETAIL: The prefix "pg_" is reserved for system schemas. > CONTEXT: while executing command on mynode01:5432 SQL state: 42939 The reason I am asking this is because there are more SQL commands afterwards where I need to do a join between the temp table and a distributed table (which is not allowed with citus extension).
Asked by Slobodan Savkovic (151 rep)
Mar 17, 2018, 10:16 PM
Last activity: Sep 27, 2021, 12:00 AM