Обсуждение: 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 .
/ \ -----------------------------------------------------------------
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 .
/ \ -----------------------------------------------------------------
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