Re: Table dependencies - Mailing list pgsql-general

From Kaarel Kitsemets
Subject Re: Table dependencies
Date
Msg-id 49E4E2BD.8070900@klaabu.com
Whole thread Raw
In response to Re: Table dependencies  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Thank you.
That worked for me :)

Kaarel

Pavel Stehule wrote:
> Hello
>
> no
>
> but, you can search tablename in source code - all stored procedures
> store src in pg_proc.prosrc column
>
> regards
> Pavel Stehule
>
> 2009/4/14 Kaarel Kitsemets <krl@klaabu.com>:
>
>> Hi
>>
>> I need to make a change to a table that many stored procedures depend on. Is
>> there an automatic way of finding all the functions that depend on a certain
>> table?
>> I have tried the dependents and dependencies report in pgAdmin but these do
>> not include functions.
>>
>> Thank you in advance,
>> Kaarel
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>>


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...
Next
From: Ivan Sergio Borgonovo
Date:
Subject: backup getting larger and larger