pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWich 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>
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:56 Guido Barosio <gbarosio@gmail.com>
parent: Rodrigo Katsumoto Sakai <rodrigo.sakai@poli.usp.br>
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 23:48 Alvaro Herrera <alvherre@commandprompt.com>
parent: Guido Barosio <gbarosio@gmail.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