Re: Table dependencies

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
>>
>>