Re: savepoint improvements

On 1/22/07, Csaba Nagy <nagy(at)ecircle-ag(dot)com> wrote:
> On Sat, 2007-01-20 at 18:08, Merlin Moncure wrote:
> [snip]
> > To be honest, I'm not a huge fan of psql tricks (error recovery being
> > another example) but this could provide a solution. in your opnion,
> > how would you use \if to query the transaction state?
>
> Wouldn't it make sense to introduce instead something like:
>
> \set language plpgsql
> ... and then redirect to plpgsql all you type ?
>
> That would give you the possibility to execute things in your favorite
> language directly from psql without creating a function.

The nature of pl/pgsql would make this impossible, or at least highly
complex and difficult...one reason is that the language has a much
more complex internal state than sql. Most other languages that I
think this would be worthwhile already their own immediate execution
interpreters.

merlin