pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how do I find which ...
2+ messages / 2 participants
[nested] [flat]

* how do I find which ...
@ 2001-03-21 07:27 datactrl <quals@bigfoot.com>
  2001-03-21 16:45 ` Re: how do I find which ... Cedar Cox <cedarc@visionforisrael.com>
  0 siblings, 1 reply; 2+ messages in thread

From: datactrl @ 2001-03-21 07:27 UTC (permalink / raw)
  To: pgsql-sql

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
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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: how do I find which ...
  2001-03-21 07:27 how do I find which ... datactrl <quals@bigfoot.com>
@ 2001-03-21 16:45 ` Cedar Cox <cedarc@visionforisrael.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Cedar Cox @ 2001-03-21 16:45 UTC (permalink / raw)
  To: datactrl <quals@bigfoot.com>; +Cc: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-03-21 16:45 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-21 07:27 how do I find which ... datactrl <quals@bigfoot.com>
2001-03-21 16:45 ` Cedar Cox <cedarc@visionforisrael.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox