Re: proposal: new contrib module plpgsql's embeded sql validator - Mailing list pgsql-hackers

From Petr Jelínek
Subject Re: proposal: new contrib module plpgsql's embeded sql validator
Date
Msg-id 4E270BE0.1080503@pjmodos.net
Whole thread Raw
In response to proposal: new contrib module plpgsql's embeded sql validator  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Another issue with invalid XML values
Next
From: Gurjeet Singh
Date:
Subject: Re: A few user-level questions on Streaming Replication and pg_upgrade