Re: Wich systema catalog table??

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Guido Barosio <gbarosio(at)gmail(dot)com>
Cc: Rodrigo Katsumoto Sakai <rodrigo(dot)sakai(at)poli(dot)usp(dot)br>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Wich systema catalog table??
Date: 2006-02-14 23:48:42
Message-ID: 20060214234841.GC32543@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Liberman 2006-02-15 01:41:47 Feedback on auto-pruning approach
Previous Message Guido Barosio 2006-02-14 15:56:14 Re: Wich systema catalog table??