Re: Creating a session variable in Postgres

From: Richard Huxton <dev(at)archonet(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Nagib Abi Fadel <nagib(dot)abi-fadel(at)usj(dot)edu(dot)lb>, generalpost <pgsql-general(at)postgresql(dot)org>
Subject: Re: Creating a session variable in Postgres
Date: 2004-06-02 16:59:05
Message-ID: 40BE0759.6020601@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bruce Momjian wrote:
> Nagib Abi Fadel wrote:
>
>>Is it possible to create a session variable for each user in Postresql ??
>
>
> No. The best you can do is create a temp table and put a value in
> there.

Would I be right in assuming that's going to be burning through OIDs
though (possibly an issue for a web-app with lots of short sessions).

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Duane Lee - EGOVX 2004-06-02 17:01:10 Re: [PERFORM] Trigger & Function
Previous Message Shachar Shemesh 2004-06-02 16:59:02 Re: ODBC, ADO, Return Value from SP problem