Re: session variable - Mailing list pgsql-bugs

From Bupp Phillips
Subject Re: session variable
Date
Msg-id bj0rnu$13q8$1@news.hub.org
Whole thread Raw
In response to session variable  (sad <sad@bankir.ru>)
Responses Re: session variable  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-bugs
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@candle.pha.pa.us> wrote in message
news:200309011657.h81Gva817128@candle.pha.pa.us...
> 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@candle.pha.pa.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@postgresql.org
>

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is it bug???
Next
From: "Stacy White"
Date:
Subject: to_timestamp not stable if date string shorter than template