News for hackers. Stuff that matters.

A comment on Show HN: Postgres Query Lock Explainer.

Re:Show HN: Postgres Query Lock Explainer by hn92726819 on Wednesday May 17, 2023 @09:04PM (#35983084)
Not a postgres expert, but it looks like this is checked by executing the query: https://github.com/AdmTal/PostgreSQL-Query-Lock-Explainer/bl...

Doesn't this mean that checking the locks in a query like:

    Delete from t;commit
Would kill everything? Or any query that can't be transactional.
[ Parent | on HN ]
Re:Show HN: Postgres Query Lock Explainer by admtal on Wednesday May 17, 2023 @09:20PM (#35983197)
The command won't work if you include "commit" in the input :)
[ Parent | on HN ]
Re:Show HN: Postgres Query Lock Explainer by runeks on Thursday May 18, 2023 @04:12AM (#35985231)
Link to relevant source code: https://github.com/AdmTal/PostgreSQL-Query-Lock-Explainer/bl...
[ Parent | on HN ]