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).