Re: pg_proc.prosrc -> can I see the function's source? - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: pg_proc.prosrc -> can I see the function's source?
Date
Msg-id 20030515075820.H60859-100000@megazone23.bigpanda.com
Whole thread Raw
In response to pg_proc.prosrc -> can I see the function's source?  (Raphael Bauduin <raphael@be.easynet.net>)
List pgsql-admin
On Thu, 15 May 2003, Raphael Bauduin wrote:

> When I look at the entry of a pg_prc_row, I get the prosrc column. Does
> that represent the id of the source of this function? Can I retrieve it
> somewhere and take a look at it without pgdump -s (didn't try it yet,
> but read in the archives that this would be a solution)?

The below is a function in C, so you won't get it even with a pgdump -s
(it's one of the foreign key triggers defined in
src/backend/utils/adt/ri_triggers.c if I remember location correctly)

>        proname        |        prosrc
> ----------------------+----------------------
>  RI_FKey_noaction_del | RI_FKey_noaction_del


pgsql-admin by date:

Previous
From: Raquel Vieira
Date:
Subject: Re: Postgresql suddenly shutdown. Please help
Next
From: tlr@kb.dk
Date:
Subject: download mirror :Cannot find server or DNS Error