Thanks a ton Laurenz and Pavel for your responses but I really didn't follow you. I am not master in PostGreSQL yet. Could you please give me some example?
Basically, I want to know how many such SET options I should reset before executing my function and at the end it should also be restored to original settings.
It would be really helpful if you could elaborate your response.
Jignesh Shah wrote: > I have been writing a function with SECURITY DEFINER enabled. > Basically, I am looking for ways to override the users SET > option settings while executing my function to prevent the > permissions breach. For example, to override "SET > search_path", I am setting search path in my function before > executing anything. Could any one please tell me what could > be other SET options that I should take care? > > Moreover, how to revert back those settings just before > returning from my function?
You can use the SET clause of CREATE FUNCTION which does exactly what you want.