> >> Um, what? No, not at all. >> >> GUCs are scoped, but not transactional, [...] >> > > The documentation is very scarse, so I have tested it. > > All tests I have done with commit & rollback on session variables (SET > SESSION) have shown a clean transactional behavior, with the value reverted > on ROLLBACK, whether intentional or automatic, or the new value set on > COMMIT. See attached scripts for instance. >
Your test shows so SET SESSION has not transactional behaviour - the transactions fails, but the value is not reverted to NULL. It is good example of antipattern for this routine type :) Pavel > > > Fabien.