Re: How to define global variable in postgresql

From: Jim Nasby <jim(at)nasby(dot)net>
To: Valentine Gogichashvili <valgog(at)gmail(dot)com>
Cc: EazonGuo <eazonguo(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to define global variable in postgresql
Date: 2011-08-22 21:37:23
Message-ID: D41D254C-B229-4BC4-AF29-2A044B920B8C@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Aug 19, 2011, at 4:15 PM, Valentine Gogichashvili wrote:
> > Hello. How can we define a global variable in postgresql?
>
> you can also use global structure in plpython for example:
>
> http://www.postgresql.org/docs/9.0/static/plpython-sharing.html

Same thing with plperl.

BTW, if you want something that's global but also transactional then you'll want to use a temp table.
--
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2011-08-22 21:54:48 Re: Displaying accumulated autovacuum cost
Previous Message Robert Haas 2011-08-22 21:25:28 cheaper snapshots redux