pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Wich systema catalog table??
3+ messages / 3 participants
[nested] [flat]

* Wich systema catalog table??
@ 2006-02-14 15:43 Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>
  2006-02-14 15:56 ` Re: Wich systema catalog table?? Guido Barosio <gbarosio@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Rodrigo Katsumoto Sakai @ 2006-02-14 15:43 UTC (permalink / raw)
  To: pgsql-admin

  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!



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Wich systema catalog table??
  2006-02-14 15:43 Wich systema catalog table?? Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>
@ 2006-02-14 15:56 ` Guido Barosio <gbarosio@gmail.com>
  2006-02-14 23:48   ` Re: Wich systema catalog table?? Alvaro Herrera <alvherre@commandprompt.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Guido Barosio @ 2006-02-14 15:56 UTC (permalink / raw)
  To: Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>; +Cc: pgsql-admin

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 ask
for the prosrc column in the pg_proc relation. But check the documentation
first.

   Best wishes,
Guido



On 2/14/06, Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br> 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 .
/ \ -----------------------------------------------------------------

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Wich systema catalog table??
  2006-02-14 15:43 Wich systema catalog table?? Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>
  2006-02-14 15:56 ` Re: Wich systema catalog table?? Guido Barosio <gbarosio@gmail.com>
@ 2006-02-14 23:48   ` Alvaro Herrera <alvherre@commandprompt.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Alvaro Herrera @ 2006-02-14 23:48 UTC (permalink / raw)
  To: Guido Barosio <gbarosio@gmail.com>; +Cc: Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>; pgsql-admin

Guido Barosio wrote:

>     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 ask
> for the prosrc column in the pg_proc relation. But check the documentation
> first.

The FK routines are actually C-language functions, and pg_proc.prosrc
won't tell you much.  Their definitions are in
src/backend/utils/adt/ri_triggers.c.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-02-14 23:48 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-14 15:43 Wich systema catalog table?? Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>
2006-02-14 15:56 ` Guido Barosio <gbarosio@gmail.com>
2006-02-14 23:48   ` Alvaro Herrera <alvherre@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox