| From: | Saravanan Shanmugam <saravanantvr1984(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Create temporary table in replica instances issues |
| Date: | 2022-07-28 08:36:09 |
| Message-ID: | CAB5b++UTpZ=5q9yTZj+KpOyH-CuLT2=p_PpyQC3zTmY=xh5N8w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Saravanan Shanmugam | 2022-07-28 09:25:14 | Re: Create temporary table in replica instances issues |
| Previous Message | Amit Langote | 2022-07-28 04:12:38 | Re: BUG #16754: When using LLVM and parallel queries aborted all session by pg_cancel_backend. |