Re: database session variables - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: database session variables
Date
Msg-id 20021002020635.GB2745@svana.org
Whole thread Raw
In response to Re: database session variables  ("Mark Wilson" <mark@mediasculpt.com>)
List pgsql-general
On Wed, Oct 02, 2002 at 01:48:46PM +1200, Mark Wilson wrote:
> Thanks Martijin,
>
> It sounds like the process_id is the 'correct' name for what I was calling
> session_id, and is what I want.  To answer your question, Oracle lets you
> have session specific variables, via package variables.

Hmm, the client can get it using $conn->backendPID in perl or PQbackendPID
in C. I don't know how you do it from the backend itself.
--
Martijn van Oosterhout   <kleptog@svana.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.

pgsql-general by date:

Previous
From: "Mark Wilson"
Date:
Subject: Re: database session variables
Next
From: Justin Clift
Date:
Subject: Re: PostgreSQL Website : advocacy.postgresql.org