X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B90159DC89E for ; Tue, 14 Feb 2006 11:56:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54008-05 for ; Tue, 14 Feb 2006 11:56:17 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.207]) by postgresql.org (Postfix) with ESMTP id 10F889DC8AE for ; Tue, 14 Feb 2006 11:56:09 -0400 (AST) Received: by uproxy.gmail.com with SMTP id m2so771018ugc for ; Tue, 14 Feb 2006 07:56:14 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=SN+OJdVUMBaVGTaa+ys475r09aHlt+cGqnU3udibAUTl4MqextkBcdtof+rpRfxv/FkUnE9DPD4AaUxNiPGjkm/gWiUCFTc3f8QPFsurGLIASGVR0p531pmXAbaIXdZc1ljD/6jLpkq6aGZR/3M5gMF0SmD97dUaxey4ZxRhK0Y= Received: by 10.66.186.4 with SMTP id j4mr1718342ugf; Tue, 14 Feb 2006 07:56:14 -0800 (PST) Received: by 10.66.224.9 with HTTP; Tue, 14 Feb 2006 07:56:14 -0800 (PST) Message-ID: Date: Tue, 14 Feb 2006 15:56:14 +0000 From: Guido Barosio To: Rodrigo Katsumoto Sakai Subject: Re: Wich systema catalog table?? Cc: pgsql-admin@postgresql.org In-Reply-To: <77E0A09C748E4247849A8B2AB069872D33B8F7@apl17.poli.usp.br> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8612_20279137.1139932574402" References: <77E0A09C748E4247849A8B2AB069872D33B8F7@apl17.poli.usp.br> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.335 required=5 tests=[AWL=0.334, HTML_MESSAGE=0.001] X-Spam-Score: 0.335 X-Spam-Level: X-Archive-Number: 200602/180 X-Sequence-Number: 20601 ------=_Part_8612_20279137.1139932574402 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Rodrigo, Your answer seems to be here: http://www.postgresql.org/docs/8.0/static/catalog-pg-proc.html If "specitifation" means the actual source of the procedure you shall as= k for the prosrc column in the pg_proc relation. But check the documentation first. Best wishes, Guido On 2/14/06, Rodrigo Katsumoto Sakai wrote: > > Hello all, > > I want to know in wich system catalog table I can see the specification > of a procedure! Exactly I'm looking for "RI_Fkey_check_ins" and > "RI_Fkey_cascade_del"! > > Thanks! > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- /"\ ASCII Ribbon Campaign . \ / - NO HTML/RTF in e-mail . X - NO Word docs in e-mail . / \ ----------------------------------------------------------------- ------=_Part_8612_20279137.1139932574402 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Rodrigo,

    Your answer seems to be here:
http://www.postgresql.org/docs/8.0/static/catalog-pg-proc.html

=    If "specitifation" means the actual source of the pr= ocedure you shall ask for the prosrc column in the pg_proc relation. But ch= eck the documentation first.

   Best wishes,
Guido

  

On 2/14/06, Rodr= igo Katsumoto Sakai <ro= drigo.sakai@poli.usp.br > wrote:
  Hello all,

  I want to know in wich syste= m catalog table I can see the specification of a procedure! Exactly I'm loo= king for "RI_Fkey_check_ins" and "RI_Fkey_cascade_del"!

  Thanks!

---------------------------(end of broad= cast)---------------------------
TIP 2: Don't 'kill -9' the postmaster



--
/"\   = ASCII Ribbon Campaign  .
\ / - NO HTML/RTF in e-mail  .
X  - NO Word doc= s in e-mail .
/ \ ------------------------------------------------------= ----------- ------=_Part_8612_20279137.1139932574402--