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

Поиск
Список
Период
Сортировка

Wich systema catalog table??

От
"Rodrigo Katsumoto Sakai"
Дата:
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!

Re: Wich systema catalog table??

От
Guido Barosio
Дата:
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 .
/ \ -----------------------------------------------------------------

Re: Wich systema catalog table??

От
Alvaro Herrera
Дата:
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