From: | Kaarel Kitsemets <krl(at)klaabu(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Table dependencies |
Date: | 2009-04-14 19:23:41 |
Message-ID: | 49E4E2BD.8070900@klaabu.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)klaabu(dot)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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan Sergio Borgonovo | 2009-04-14 19:32:34 | backup getting larger and larger |
Previous Message | vj | 2009-04-14 18:56:40 | Using CHECK while CREATE'ing table |