Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 8A3996334D3 for ; Sat, 13 Mar 2010 14:00:49 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 70102-10 for ; Sat, 13 Mar 2010 18:00:37 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id C16FB63277A for ; Sat, 13 Mar 2010 14:00:38 -0400 (AST) Received: by wyb38 with SMTP id 38so970815wyb.19 for ; Sat, 13 Mar 2010 10:00:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=QvxMelfUXPw23DOh/OV2Aua8WMTVpfwB8SGm6VBHPwY=; b=cGYG++R9r+7OOTjuqijDMSYNnaMMGs82hAj5F6rv+7zFPK0gyonjQLEwudyuhxhpRz xUEzhXeMIYOPtDy6P1d6mWVRQRSuWSvphBWEvqWQpv5gKPW9sJV2kJ1gHCgw1XaSLpKF TLc300VyQYFRE+LhmgQduiaIT95haQ7AwsbPc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=wkZABOKvebBzHQxXFp16UeCISNf/CUjnjWhx9/p5+Fi/pdwTAkaF7R4aQMEbtxVldI ZmVq7ofR6JbSSfAOtmM/hPj4N9uxff4/xNlUtkx/CIs5p/P3JvflVlslAzXX5DfWjcuA q9bje6PLJRtpv4fEIxnfqhtIRtAID4XKlu5fc= MIME-Version: 1.0 Received: by 10.216.85.17 with SMTP id t17mr663962wee.178.1268503236570; Sat, 13 Mar 2010 10:00:36 -0800 (PST) In-Reply-To: <4B9BD20B.9090601@gmail.com> References: <4B9BD20B.9090601@gmail.com> Date: Sat, 13 Mar 2010 19:00:36 +0100 Message-ID: <162867791003131000o20cd83d9ie297a8a50eaa5e9d@mail.gmail.com> Subject: Re: Private functions From: Pavel Stehule To: Gianvito Pio Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.438 tagged_above=-10 required=5 tests=AWL=0.161, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/70 X-Sequence-Number: 33777 Hello directly no. There is only workaround - you can verify inside in function content of pg_stat_activity_table - but this have to have a superuser rights. Regards Pavel Stehule 2010/3/13 Gianvito Pio : > Hi all, > is there a way to write a function that can only be called by another > function but not directly using SELECT function_name ( )? > Thanks > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >