Re: [BUGS] session variable

2003-09-03 Thread Bruce Momjian
sad wrote: > On Monday 01 September 2003 20:57, you wrote: > > 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 w

Re: [BUGS] session variable

2003-09-02 Thread Andreas Pflug
Bupp Phillips wrote: Could you possible have some type of variable (preferably the Transaction ID) that can identify an individual process? There's pg_backend_pid() for 7.4 and backend_pid() as contrib module for earlier releases. Regards, Andreas ---(end of broadcast)

Re: [BUGS] session variable

2003-09-02 Thread Bupp Phillips
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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > sad wrote: > > Good day > > > > is

Re: [BUGS] session variable

2003-09-02 Thread Andreas Pflug
sad wrote: 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.

Re: [BUGS] session variable

2003-09-02 Thread sad
On Monday 01 September 2003 20:57, you wrote: > 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 varib

Re: [BUGS] session variable

2003-09-01 Thread Bruce Momjian
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

[BUGS] session variable

2003-09-01 Thread sad
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 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if yo