Functions

Mihai Gheorghiu wrote:

I created 2 functions: f1 and f2. f1 calls f2. I then change f2.
What is the minimum I need to do for f1 to see the modified f2?
Is my understanding correct that I need to drop and recreate f1?
Thank you in advance.

For functions called by functions, it should be sufficient to
reconnect to the database. AFAIK neither 'sql', nor any
existing PL's can cache function OIDs across DB connection
time.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com