Tilmann Singer <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 1: 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
