Sorry I don't have the exact message right now, but YES.
To be exact, drop table | schema pg_temp_XX... in single-user mode results in "HINT: run vaccum"
On Tue, Feb 19, 2019 at 12:11 AM Arthur Zakirov <a.zakirov@xxxxxxxxxxxxxx> wrote:
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
