Re: proof concept - access to session variables on client side - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proof concept - access to session variables on client side
Date
Msg-id CAFj8pRCjFgqJFCvqt4CZh3d66u=nH1h5GRP48-XLscMpHmADbQ@mail.gmail.com
Whole thread Raw
In response to Re: proof concept - access to session variables on client side  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
2012/7/3 Peter Eisentraut <peter_e@gmx.net>:
> On tis, 2012-06-26 at 07:06 +0200, Pavel Stehule wrote:
>> A motivation is integration of possibilities of psql console together
>> with stronger language - plpgsql. Second target is enabling
>> possibility to save a result of some server side process in psql. It
>> improve vars feature in psql.
>
> I think it would be better if DO could be extended into some kind of
> "lambda", taking parameters and returning a value.  Then you can use
> existing infrastructure for passing values and saving the return.  It
> would also extend better to other languages.

I did it
http://archives.postgresql.org/pgsql-hackers/2010-07/msg00118.php

it is other approach. I think so callback from server to client is
more general solution - access to client system variables is possible,
but I know so this is very obscure and risk idea.

but any form of parametrization of PL block can be nice.

Regards

Pavel


>


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: proof concept - access to session variables on client side
Next
From: Tom Lane
Date:
Subject: Re: Support for XLogRecPtr in expand_fmt_string?