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

#1

On Apr 5, 2006, at 7:28 AM, William Leite Ara=FAjo wrote:

Quote:

On 4/3/06, Tom Lane <tgl (AT) sss (DOT) pgh.pa.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=20=20
returns.
I'm doing things simillar to this to create users automatically,=20=20
and works fine...

As Tom mentioned, it's probably an issue of waiting on a lock that it=20=20
can't acquire. Just because it worked for creating users doesn't mean=20=20
it's a good idea. It's certainly less efficient than a SECURITY=20=20
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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #2372: dblink_exec doesn't return. NEVER! - 04-06-2006 , 08:47 AM