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. # #================================================== [EMAIL PROTECTED] # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html