On 18.02.2019 17:18, Jahwan Kim wrote:
Thanks for the reply.
(1) The problem is, I cannot drop any of the temp tables, not even in
the single-user mode. It says
'vacuum', 'You might also need to commit or roll back old prepared
transactions.'
And, no, there seems to be no pending prepared transaction either.
Can you show the exact whole message?
Do I understand correctly. Are temp tables persist in pg_class even
after trying to drop temp tables in single-user mode?
--
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
