Tilmann Singer <tils-pgsql(at)tils(dot)net> 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.