Re: how to clear the query history?

Поиск
Список
Период
Сортировка
От Aditya Toshniwal
Тема Re: how to clear the query history?
Дата
Msg-id CAM9w-_nBEF9p0F47ra0bnRGq9RHWxW--mgN9Evr5VaAvE41u9Q@mail.gmail.com
обсуждение исходный текст
Ответ на how to clear the query history?  (Peter <pmc@citylink.dinoex.sub.org>)
Ответы Re: how to clear the query history?  (Peter <pmc@citylink.dinoex.sub.org>)
Список pgadmin-support
Hi Peter,


On Thu, Aug 4, 2022 at 5:57 PM Peter <pmc@citylink.dinoex.sub.org> wrote:
Hi,

 this is pgadmin4, 6.11

 when trying to open Query-Tool I get this error, and the tab is
opened empty and stale (unremoveable):

Failed to fetch Query History
Error: Minified React error #31;
visit
https://reactjs.org/docs/error-decoder.html?invariant=31&args[]=object%20with%20keys%20%7B%7D
for the full message

This happens only on a specific database. When I open Query Tool for
a different database, then switch the Tab back from "Query
History" to "Query", then it works again.

Using a different browser does not help, restarting the pgadmin4
server doesn't help either. Apparently that Query History data got
persistently botched.
Where is that stored, so I can clean it out?
If you're using the desktop variant then you'll find a file pgadmin4.db SQLite file in the .pgadmin directory of user home.
If on server mode then it should be in /var/lib/pgadmin.
You can open the .db file and clear the query_history table.


This has apparently happened while I was trying to somehow enable
selection from firefox about:config. So when we're at it: is there a
way to enable selection in the editor?

This is a FreeBSD desktop, and we have two cut&paste tools:
 - the selection: mark something with left-mouse, point somewhere else
   and insert it with middle-mouse.
 - the Clipboard: mark something with left-mouse, hit Ctrl-C. point
   somewhere else and insert with Ctrl-V.

Both do normally work, the exception is the pgadmin4 editor, where
the selection appears to be disabled. Since my normal web application
editor (javascript only) does work nicely with both, this must be
something specific to pgadmin4.
pgAdmin4 editor selection is not disabled. Can you share a screen recording to understand better?  


-- PMc




--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"

В списке pgadmin-support по дате отправления:

Предыдущее
От: Peter
Дата:
Сообщение: how to clear the query history?
Следующее
От:
Дата:
Сообщение: Slow Scripts - Create Script