Re: proposal: new contrib module plpgsql's embeded sql validator

On 07/20/2011 05:24 AM, Tom Lane wrote:
> Petr Jelínek<pjmodos@pjmodos.net>  writes:
>> But, I think we should add valitation hook to plpgsql plugin structure
>> so that you don't have to actually execute the function to check it -
>> curretly there are only executing hooks which is why the plugin only
>> works when you the func (not good for automation).
> If you mean that such checks would be done automatically, no, they
> shouldn't be.  Consider a function that creates a table and then uses
> it, or even just depends on using a table that doesn't yet exist when
> you do CREATE FUNCTION.

No, certainly not by default, I would just like to be able to do it 
automatically without having to call the function.

--
Petr Jelinek