Re: [GENERAL] Grep'ing for a string in all functions in a schema?

2014-01-31 Thread hubert depesz lubaczewski
On Thu, Jan 30, 2014 at 12:52:35PM -0800, bricklen wrote: Since Postgres does not consider a table as a dependency of a function if that table is referenced in the function (probably a good reason), I often find myself in a position of asking is this table/sequence/index referenced in any

[GENERAL] Grep'ing for a string in all functions in a schema?

2014-01-30 Thread Wells Oliver
Since Postgres does not consider a table as a dependency of a function if that table is referenced in the function (probably a good reason), I often find myself in a position of asking is this table/sequence/index referenced in any of these N number of functions? Is there an easy way of

Re: [GENERAL] Grep'ing for a string in all functions in a schema?

2014-01-30 Thread bricklen
On Thu, Jan 30, 2014 at 12:45 PM, Wells Oliver wellsoli...@gmail.comwrote: Since Postgres does not consider a table as a dependency of a function if that table is referenced in the function (probably a good reason), I often find myself in a position of asking is this table/sequence/index

Re: [GENERAL] Grep'ing for a string in all functions in a schema?

2014-01-30 Thread Wells Oliver
This is the most helpful thing I've seen in months. Bravo. On Thu, Jan 30, 2014 at 12:52 PM, bricklen brick...@gmail.com wrote: On Thu, Jan 30, 2014 at 12:45 PM, Wells Oliver wellsoli...@gmail.comwrote: Since Postgres does not consider a table as a dependency of a function if that table is

Re: [GENERAL] Grep'ing for a string in all functions in a schema?

2014-01-30 Thread Jeff Janes
On Thu, Jan 30, 2014 at 12:45 PM, Wells Oliver wellsoli...@gmail.comwrote: Since Postgres does not consider a table as a dependency of a function if that table is referenced in the function (probably a good reason), I often find myself in a position of asking is this table/sequence/index

Re: [GENERAL] Grep'ing for a string in all functions in a schema?

2014-01-30 Thread Thomas Kellerer
Wells Oliver wrote on 30.01.2014 21:45: Since Postgres does not consider a table as a dependency of a function if that table is referenced in the function (probably a good reason), I often find myself in a position of asking is this table/sequence/index referenced in any of these N number of