Using \set AUTOCOMMIT off you can make psql switch to transactional behavior. This is great, because while doing some INSERTs or UPDATEs, it gives you way to review the results and ABORT. However, mistakes in SELECT queries also abort the transaction:
ERROR: current transaction is aborted, commands ignored until end of transaction block
This is annoying, and while understandable, seemingly serves me no good, so I'm wondering if there's a more fine-grained configuration possible, i.e. only ABORT on certain types of queries? (I appreciate that SELECT may have side-effects, and this may be why this is a problem, but I'm asking anyway, to be sure.) Alternatively, is there a way to avoid me having to explicitly ABORT, after this happens?