Re: proposal: new contrib module - session variables - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal: new contrib module - session variables
Date
Msg-id 162867790806091033s1b522cd2p23b0b3c0add9f8f@mail.gmail.com
Whole thread Raw
In response to Re: proposal: new contrib module - session variables  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: proposal: new contrib module - session variables  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
2008/6/9 Andrew Dunstan <andrew@dunslane.net>:
>
>
> Pavel Stehule wrote:
>>
>> Hello all,
>>
>> session variables are missing feature long time. Currently nobody
>> works on package or SQL/PSM module implementation so there is some
>> gap.Currently best know solution are session variables based on plper
>> hash tables or Joe Conway's C implementation.
>>
>> I propose include Joe's code into contrib set
>> http://www.joeconway.com/sessfunc.tar.gz It's important mainly for
>> window's users, that has problems with own compilation.
>>
>> Objections?
>>
>>
>
> The URL fails, so I can't comment on Joe's work. But I seriously doubt that
> any contrib module is really the right way to go about doing session
> variables. If we're going to have them then they need to be properly
> builtin, and available to all PLs.
>

probably Joe's server is out currently :(.

Joe's implementation was simply - hash table stored in session context.

Pavel


> cheers
>
> andrew
>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposal: GiST constraints
Next
From: "Nathan Boley"
Date:
Subject: Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics