Re: custom session variables?

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

In response to

Responses

Browse pgsql-general by date

  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