Обсуждение: Wich systema catalog table??

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!

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

  




--
/"\   ASCII Ribbon Campaign  .
\ / - NO HTML/RTF in e-mail  .
X  - NO Word docs in e-mail .
/ \ -----------------------------------------------------------------

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