Hi Experts,
We are using apache connection pooling and we want to use the temporary tables.
I know pgbouncer and pgpool provide DISCARD ALL command when the connection given back to pool so that temporary tables created in a session are dropped.
Is there any way in apache connection pooling. Do anyone have experience ?
My PostgreSQL version is 9.6.
NOTE: I know that I can insist my application team to put drop temporary table in their code but there are some situations where they are not dropping.
Thanks
Srinivas