Re: BUG #2372: dblink_exec doesn't return. NEVER! - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2372: dblink_exec doesn't return. NEVER!
Date
Msg-id 17081.1144100907@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #2372: dblink_exec doesn't return. NEVER!  ("William Leite Araújo" <william.bh@gmail.com>)
Responses Re: BUG #2372: dblink_exec doesn't return. NEVER!  ("William Leite Araújo" <william.bh@gmail.com>)
List pgsql-bugs
"William Leite Araújo" <william.bh@gmail.com> writes:
>      I need this to give a credit from canceled billets.
>      But anyone instead of roots can insert on this table.
>      If it's done by a function, only roots must run it. So, the trigger
> will fail because is runned a no "su"...

You need to read up on SECURITY DEFINER functions.
        regards, tom lane


pgsql-bugs by date:

Previous
From: "William Leite Araújo"
Date:
Subject: Re: BUG #2372: dblink_exec doesn't return. NEVER!
Next
From: "Anthony Ransley"
Date:
Subject: BUG #2373: postgres.exe crashes