3 ms·
> Likewise you can specify a database connection as read-only so that it wont run modifier queries at all, attempting to do so will stop you but you can then ex
by koolba 4y ago
> Likewise you can specify a database connection as read-only so that it wont run modifier queries at all, attempting to do so will stop you but you can then explicitly run it if you need to.
Does it parse the SQL and guess if it’s DML or run it in a transaction and rollback after?
Because “SELECT foo(‘bar’)” could perform DML.
- canadianfella 4y ago[dead]
- philliphaydon 4y agoSo I just quickly tested this and it appears to block it. I created a function to modify then set the connection to readonly. https://prnt.sc/0mNHkGIa1klR https://prnt.sc/0mNHkGIa1klR