3 ms·
Not a postgres expert, but it looks like this is checked by executing the query: https://github.com/AdmTal/PostgreSQL-Query-Lock-Explainer/blob/master/pg_explai
by hn92726819 3y ago
Not a postgres expert, but it looks like this is checked by executing the query: https://github.com/AdmTal/PostgreSQL-Query-Lock-Explainer/blob/master/pg_explain_locks.py#L60 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.
- admtal 3y agoThe command won't work if you include "commit" in the input :)
- runeks 3y agoLink to relevant source code: https://github.com/AdmTal/PostgreSQL-Query-Lock-Explainer/blob/da1c5fcfe7b1d5f8755c0203ad66ea0e3828c00f/pg_explain_locks.py#L148-L153 https://github.com/AdmTal/PostgreSQL-Query-Lock-Explainer/bl...