Hi hackers, A colleague of mine wondered if there is a way to always run everything you type into psql in a db txn and automatically rollback it as soon as it finish. I couldn't think of any way to do so, but thought it would be a nice feature and probably quite easy to add to psql, so I thought I should suggest it here.
The typical use-case is you are doing something in production that you just want to a) test if some query works like expected and then rollback or, b) read-only queries that should not commit any changes anyway, so here the rollback would just be an extra layer of security, since your SELECT might call volatile functions that are actually not read-only Thoughts? /Joel -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers