| From: | Cedar Cox <cedarc(at)visionforisrael(dot)com> |
|---|---|
| To: | datactrl <quals(at)bigfoot(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: how do I find which ... |
| Date: | 2001-03-21 16:45:29 |
| Message-ID: | Pine.LNX.4.21.0103211842460.32292-100000@nanu.visionforisrael.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, 21 Mar 2001, datactrl wrote:
> I write some functions inPL/pgSQL. If I drop a function B , which is called
> by function A, and create function B again, then function A won't work
If I recall correctly, this is because function A's "compiled" code refers
to the oid of the now non-existent function B. Aren't functions
"compiled" once per connection (/ backend process)? If so, reconnecting
should do it. (Then again, I might be totally wrong ... :]
> unless I drop function A and re-create again. How about if there are lots
> functions call to function B, is there any way to search system table to
> find out those functions call to A?
>
> JACK
-Cedar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ligia Pimentel | 2001-03-21 17:25:09 | Error when selecting rows from a temporary table in ODBC |
| Previous Message | Cedar Cox | 2001-03-21 16:40:02 | Re: Maybe a Bug, maybe bad SQL |