'How to concurrently update PostgreSQL 13 table row without locks

I need to update a table with different measures per id and these updates will be run by different transactions.

I need to know if there is a way to unlock the row on the update statement as I do not need to read data at the moment and data consistency would not be a problem.

Thanks in advance.

postgresqlconcurrencytransactionslockingpostgresql-13cssweb-scrapingcss-selectorspuppeteer


Solution 1:[1]

Finally I have implemented the different transactions (insert, update) inside a procedure and released the locks with COMMIT after each transaction in order to avoid deadlocks, following this comment: https://stackoverflow.com/a/56768529

Solution 2:[2]

From the code it seems the EA website is created with Web Components and the part of the code you are trying to access is in Shadow DOM.

Quoting from Wikipedia:

Shadow DOM is a functionality that allows the web browser to render DOM elements without putting them into the main document DOM tree.

That is why your XPath does not find it.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Tomas Korinek

Related Questions