Re: BUG #2372: dblink_exec doesn't return. NEVER!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: William Leite Araújo <william(dot)bh(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2372: dblink_exec doesn't return. NEVER!
Date: 2006-04-03 21:48:27
Message-ID: 17081.1144100907@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"=?ISO-8859-1?Q?William_Leite_Ara=FAjo?=" <william(dot)bh(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Anthony Ransley 2006-04-03 22:31:11 BUG #2373: postgres.exe crashes
Previous Message William Leite Araújo 2006-04-03 21:38:09 Re: BUG #2372: dblink_exec doesn't return. NEVER!