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

On Apr 5, 2006, at 7:28 AM, William Leite Araújo wrote:

> On 4/3/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> (...)
> You need to read up on SECURITY DEFINER functions.
>
> regards, tom lane
>
>
> Ok, I'll do this way, but still don't understand why it doesn't
> returns.
> I'm doing things simillar to this to create users automatically,
> and works fine...

As Tom mentioned, it's probably an issue of waiting on a lock that it
can't acquire. Just because it worked for creating users doesn't mean
it's a good idea. It's certainly less efficient than a SECURITY
DEFINER function, for starters...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461