Re: setting custom session variables? - Mailing list pgsql-novice

From Raphael Bauduin
Subject Re: setting custom session variables?
Date
Msg-id 419DC906.6010902@be.easynet.net
Whole thread Raw
In response to Re: setting custom session variables?  (Joe Conway <mail@joeconway.com>)
List pgsql-novice
Joe Conway wrote:
> Tom Lane wrote:
>
>> Raphael Bauduin <raphael.bauduin@be.easynet.net> writes:
>>
>>> Can I set my own postgresql session variables?
>>
>>
>> Not in existing releases.  There is a feature in 8.0 that you could
>> use (or misuse?) that way.
>>
>
> Also see myfunc_setvar(), myfunc_getvar, and myfunc_rmvar() in:
>   http://www.joeconway.com/myfunc.tgz
> for an example of how you could make your own. There is an article that
> briefly describes these functions here:
> http://www.onlamp.com/pub/a/onlamp/2004/06/28/postgresql_extensions.html
>

I finally had the time to test it and it does exactly what I need.
That saves us a lot of work, just as tablefunc does.

Thanks a lot!

Raph


>
> HTH,
>
> Joe


pgsql-novice by date:

Previous
From: George Weaver
Date:
Subject: Installing XpSQL or contrib modules
Next
From: Kjetil Haaland
Date:
Subject: Re: user defined type