[BUGS] session variable

#1

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 your
joining column's datatypes do not match

#2

sad wrote:

Quote:

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.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 (AT) postgresql (DOT) org

#3

On Monday 01 September 2003 20:57, you wrote:

Quote:

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.

that's ok, unless i need to access it in a trigger.

where may i ask a programming and perfomance question?
i think mailing such questions to "BUGS" is not a good idea.=20

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

#4

sad wrote:

Quote:

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.

that's ok, unless i need to access it in a trigger.

No problem to use a temp table in a trigger (which is local to the

session), I do so myself. Still, session variables would be nice, making
coding a little bit more comfortable.

Quote:

where may i ask a programming and perfomance question?
i think mailing such questions to "BUGS" is not a good idea.

Just use the pgsql-sql and pgsql-performance mailing lists.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#5

Bupp Phillips wrote:

Quote:

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)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

#6

sad wrote:

Quote:

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 varibles.
You could create a temp table and put a value in there easily.

that's ok, unless i need to access it in a trigger.

Why can't you grab it out of the temp table from the trigger?

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) 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 8: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[BUGS] session variable

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

[BUGS] session variable - 09-01-2003 , 09:10 AM

Re: [BUGS] session variable - 09-01-2003 , 11:58 AM

Re: [BUGS] session variable - 09-02-2003 , 07:27 AM

Re: [BUGS] session variable - 09-02-2003 , 07:41 AM

Re: [BUGS] session variable - 09-02-2003 , 05:52 PM

Re: [BUGS] session variable - 09-03-2003 , 12:55 PM