Re: database session variables

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-02 02:06:35
Message-ID: 20021002020635.GB2745@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2002-10-02 02:07:46 Re: PostgreSQL Website : advocacy.postgresql.org
Previous Message Gerhard Häring 2002-10-02 01:52:37 Re: PostgreSQL Website : advocacy.postgresql.org