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

On 4/3/06, Tom Lane <[EMAIL PROTECTED]> 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      [EMAIL PROTECTED]
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

Reply via email to