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
Last activity: Sep 27, 2021, 12:00 AM