From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
---|---|
To: | Darren Duncan <darren(at)darrenduncan(dot)net> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org>, Christian Hammers <ch(at)lathspell(dot)de> |
Subject: | Re: custom session variables? |
Date: | 2013-04-25 02:16:17 |
Message-ID: | CAFcNs+r=bh+47LGH4tmEvtu+2_uo6mEJ375zP1xUHLtgw+-aNQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Apr 24, 2013 at 9:47 PM, Darren Duncan <darren(at)darrenduncan(dot)net>wrote:
> Thank you for that.
>
> I had actually thought of this, but it seemed to me that using a temporary
> table was a heavy-handed approach and that a temporary scalar variable
> would be more efficient or less verbose to use.
>
> It is *a* solution certainly, and potentially a better one than the url I
> pointed to, but I was hoping for something less bulky.
>
> Granted, I realize that sequence generators are basically small tables
> like this behind the scenes, but is there any appreciable overhead of
> creating and dropping a temporary table for every session?
>
>
Hi,
Maybe you must see this extension [1] ;-)
[1] http://pgxn.org/dist/session_variables/
<http://pgxn.org/dist/session_variables/>--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-04-25 02:21:18 | Re: Regarding template1 database |
Previous Message | S H | 2013-04-25 01:48:14 | Re: Regarding template1 database |