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

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