Postgres Pro
Downloads
Home   >   mailing lists

Create temporary table in replica instances issues - Mailing list pgsql-bugs

From Saravanan Shanmugam
Subject Create temporary table in replica instances issues
Date
Msg-id CAB5b++UTpZ=5q9yTZj+KpOyH-CuLT2=p_PpyQC3zTmY=xh5N8w@mail.gmail.com
Whole thread Raw
Responses Re: Create temporary table in replica instances issues
Re: Create temporary table in replica instances issues
List pgsql-bugs
Tree view
Hello, 

We have AWS RDS with Primary and replica node to balance IO RW for application performance, 

In such cases we will be livergaing all read related queries to replica nodes, 
sometimes we will create temp tables not physical tables and do some complicated queries .  

PG SQL replica node throws Create table not allowed in reader-instance 
But this not Physical table its temporary table, in MS-SQL and MYSQL are supporting, Why Pgsql is not supporting?? 

Please do we have this option to enable or is this a bug??



--
Many thanks,
Saravanan Shanmugam
Mobile : +918939939234

pgsql-bugs by date:

Previous
From: Amit Langote
Date:
Subject: Re: BUG #16754: When using LLVM and parallel queries aborted all session by pg_cancel_backend.
Next
From: Saravanan Shanmugam
Date:
Subject: Re: Create temporary table in replica instances issues