Re: leaky views, yet again - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: leaky views, yet again
Date
Msg-id m2lj69due1.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: leaky views, yet again  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Hi,

Stephen Frost <sfrost@snowman.net> writes:
> Wow, I just kind of assumed you could; I'm not really sure why.  Perhaps
> it'll be possible in the future though, so might be something to think
> about if/when it happens.  Can't see a way to abuse the view from inside
> a DO or in a function in the same way either.

It took me some time and reviewing the patch to think about it this way,
so maybe that would help some readers here: DO is a utility command, not
a query. That also explains why it does not get parameters.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Issues with Quorum Commit
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: plpgsql, solution for derivated types of parameters