Josh Berkus <[EMAIL PROTECTED]> writes: > Question: How will these "system variables" behave regarding transactions? > If I update a system variable and roll back the transaction, does it change > back? Do changes in a running transaction remain invisible until COMMIT? > Excuse me if you've already answered these; I've not caught up on my -hackers > backlog since I broke my foot.
I think this is precisely the objection. He wants something that allows him to break out of transaction semantics entirely. Other backends would see the value he sets before he commits. If he rolls back his changes would remain. I expect to see substantial resistance to incorporating such a feature. One argument will be that he should simply use a separate system for such data. For example, memcached would be much faster and more scalable than communicating via postgres. The only disadvantage to using something like memcached would be that you couldn't transparently use values from there inside your queries. You would have to fetch them and then pass them as parameters to postgres. -- greg ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly