Le 29/08/2011 13:44, Andreas a écrit :
> how can I correct schema-names within function when the schema gets
> PG corrects automagicaly every view and foreign key.
> Though I found that it doesn't update the schema-name in sql-functions.
> Say there where a table "bar" in the schema "foo"
> and there is a function f(int) that results to "select * from foo.bar
> where id = $1".
> Then I rename "foo" to "sansi" and all seems nice till I call f().
> Now I get an error that schema "foo" can't be found.
> How could I find all functions that use the now uncorrect schema-name?
Not sure, but the query below might help :
WHERE prosrc LIKE '%foo.%';
dalibo.com | dalibo.org
In response to
pgsql-novice by date
|Next:||From: Merlin Moncure||Date: 2011-08-29 13:41:09|
|Subject: Re: How to correct schema-names within function when the
schema gets renamed?|
|Previous:||From: pasman pasmański||Date: 2011-08-29 11:55:22|
|Subject: Re: nice updates|