| From: | Petr Jelínek <pjmodos(at)pjmodos(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Jim Nasby <jim(at)nasby(dot)net>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: proposal: new contrib module plpgsql's embeded sql validator |
| Date: | 2011-07-20 17:09:52 |
| Message-ID: | 4E270BE0.1080503@pjmodos.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 07/20/2011 05:24 AM, Tom Lane wrote:
> =?ISO-8859-1?Q?Petr_Jel=EDnek?=<pjmodos(at)pjmodos(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gurjeet Singh | 2011-07-20 17:17:32 | Re: A few user-level questions on Streaming Replication and pg_upgrade |
| Previous Message | Tom Lane | 2011-07-20 17:06:17 | Re: Another issue with invalid XML values |