Tilmann Singer <tils-pgsql@xxxxxxxx> writes: > So the view will reference the original table and not the temporary > table. Is there a way to achieve this kind of transaction local > setting? A transaction based solution would give more security in a > situation where a web app server uses a connection pool and you can > not guarantee 100% that your reset code is called properly at request > init. Nop, you do the reset part *at the end* of the request cycle: set session id handle request reset session id So, you can guarantee that the id of the session is reset and the connection properly disposed to the pool. Regards, Manuel.
