| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Mark Wilson <mark(at)mediasculpt(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: database session variables |
| Date: | 2002-10-01 23:49:39 |
| Message-ID: | 20021001234939.GA2408@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Oct 02, 2002 at 10:27:10AM +1200, Mark Wilson wrote:
> Hi all,
>
> I am working on a system architecture that requires accessing session
> variables specific to the database connection. This is useful because you
> can emulate many users (with different privileges) with a single database
> logon. Currently it seems like only user, current_user and session_user
> are supported.
Well, you can get the process ID of the backend process. This would be
different for every connection.
What other database allow you to store session specific variables?
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2002-10-02 00:34:49 | New PostgreSQL Website : advocacy.postgresql.org |
| Previous Message | Dan Ostrowski | 2002-10-01 23:18:41 | Re: Major Problem with locale |