[GENERAL] Table dependencies

2009-04-14 Thread Kaarel Kitsemets
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

Re: [GENERAL] Table dependencies

2009-04-14 Thread Kaarel Kitsemets
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 : Hi I need to make a change to a table that many stored