Re: session variable

From: "Bupp Phillips" <hello(at)noname(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: session variable
Date: 2003-09-02 01:28:47
Message-ID: bj0rnu$13q8$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-sql

Could you possible have some type of variable (preferably the Transaction
ID) that can identify an individual process?

If something like this already exist, then disregard this post.

"Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote in message
news:200309011657(dot)h81Gva817128(at)candle(dot)pha(dot)pa(dot)us(dot)(dot)(dot)
> sad wrote:
> > Good day
> >
> > is it possible to define user variables in session ?
> > If not then is it planned to implement ?
> > or it is principially impossible in PosqtgreSQL
>
> psql has variables, but in general we don't support session varibles.
> You could create a temp table and put a value in there easily.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania
19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-09-02 04:17:28 Re: Vacuum I/O throttling
Previous Message Guy Thornley 2003-09-01 23:48:59 Re: Vacuum I/O throttling

Browse pgsql-sql by date

  From Date Subject
Next Message Rute Solipa 2003-09-02 08:29:05 unsubscribe
Previous Message Peter Eisentraut 2003-09-01 22:00:15 Re: Trigger functions w/o pgsql ?