Re: [SQL] Before/After Trigger User Switching

2003-08-20 Thread Tom Lane
"Aasmund Midttun Godal" <[EMAIL PROTECTED]> writes: > Thank you for your quick reply! > I understand your point of view, however the fact remains that you want the > action to be done as though it was the DEFINER user that did it, and that > has not changed even thoug the function itself has fin

Re: [SQL] Before/After Trigger User Switching

2003-08-20 Thread Aasmund Midttun Godal
Thank you for your quick reply! I understand your point of view, however the fact remains that you want the action to be done as though it was the DEFINER user that did it, and that has not changed even thoug the function itself has finished? regards, aasmund. Tom Lane writes: "Aasmund

Re: [SQL] Before/After Trigger User Switching

2003-08-20 Thread Tom Lane
"Aasmund Midttun Godal" <[EMAIL PROTECTED]> writes: > When an operation is done throug a SECURITY DEFINER style function and > causes a trigger the current_user depends on whether it is executed BEFORE > or AFTER. I currently run 7.3.2. I believe the BEFORE behavior is correct > while the AFTER

Re: [SQL] Before/After Trigger User Switching

2003-08-20 Thread Aasmund Midttun Godal
I have upgraded to 7.3.4 and the problem persists. Aasmund Midttun Godal writes: When an operation is done throug a SECURITY DEFINER style function and causes a trigger the current_user depends on whether it is executed BEFORE or AFTER. I currently run 7.3.2. I believe the BEFORE behavior is

[SQL] Before/After Trigger User Switching

2003-08-20 Thread Aasmund Midttun Godal
When an operation is done throug a SECURITY DEFINER style function and causes a trigger the current_user depends on whether it is executed BEFORE or AFTER. I currently run 7.3.2. I believe the BEFORE behavior is correct while the AFTER behavior is wrong. A bug? already fixed? regards, Aasmun