On Sun, Sep 11, 2011 at 01:21, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I'm not that happy with overloading the ANALYZE keyword to mean this
> But we could certainly use some other name --- I'm
> inclined to suggest CHECK:
> CHECK FUNCTION function_name(arglist);
Just a thought: pg_check_function(oid)?
> People would want some sort of wild card capability; at the very least
> "check all plpgsql functions owned by me".
SELECT pg_check_function(p.oid) FROM pg_proc p
JOIN pg_user ON (usesysid=proowner) WHERE usename=current_user;
Regards,
Marti