I want to design some (a significant number of) views able to select records
from various tables for, say, current_client_account_number, which I would
like to store/set in a table (not in a variable). Creating a temp table for
storing these current_client_account_number would not help, because any
pre-designed view will not see the temp table created by the user session.
The reason why I want to design these views is that I want to design rules
to deal with updates/inserts, which would be the only objects that users
will have access to.
I need the PG session ID and not the current user, because the same user may
have more than one session, from different machines or frontends.
Any suggestions?
-----Original Message-----
From: Brett W. McCoy <bmccoy@chapelperilous.net>
To: Mihai Gheorghiu <tanethq@earthlink.net>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Wednesday, October 10, 2001 11:16 AM
Subject: Re: [GENERAL] Session identifier
>On Wed, 10 Oct 2001, Mihai Gheorghiu wrote:
>
>> Is there anything like a session ID? How can I read it?
>> I want to store it in a table together with some other data.
>
>Session ID for use with what? This is something best handled by your
>client application (like with Apache::Session:DBI).
>
>-- Brett
> http://www.chapelperilous.net/
>------------------------------------------------------------------------
>"Probably the best operating system in the world is the [operating system]
> made for the PDP-11 by Bell Laboratories." - Ted Nelson, October 1977
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)