Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> writes:
> I have a question about what does happen if search path is not defined
> for SECURITY DEFINER function. My expectation is that SECURITY DEFINER
> function should defined empty search patch in this case.
Your expectation is incorrect. We are not in the business of breaking
every application in sight, which is what that would do. Nor do I think
it's a good plan to try to be smarter than the programmer.
regards, tom lane