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 <[EMAIL PROTECTED]> To: Mihai Gheorghiu <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
