Re: database session variables - Mailing list pgsql-general

From Mike Mascari
Subject Re: database session variables
Date
Msg-id 3D9A56E9.8020602@mascari.com
Whole thread Raw
In response to database session variables  ("Mark Wilson" <mark@mediasculpt.com>)
List pgsql-general
Martijn van Oosterhout wrote:
> 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.

Why not write a little server-side C function to return the
result of getpid()?

Mike Mascari
mascarm@mascari.com





pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: database session variables
Next
From: "Mark Wilson"
Date:
Subject: Re: database session variables