Yeah I was thinking of using the @transactional annotation to do transactions in postgres and wanted to verify that postgres supported this annotation. Use case would be to set session variables and then use a table filter that referenced the session variables. Requires multiple queries to be run in the same session/transaction
Seeing conflicting information and wanted to confirm that the transactional annotation was supported by sping jdbc. Also wanted to see if anyone had attempted to set session variables in postgres before executing a query.