| 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: | Whole Thread | Raw Message | 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 |