Search Postgresql Archives

Re: "Cache lookup failed for function" when recreating procs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Chris Fischer" <Chris.Fischer@xxxxxxxxxxxxxxxxxx> writes:
> I'm attempting to write a function which produces a script.  The script
> will contain steps necessary to drop/recreate all the functions.

If you're trying to modify functions that are in live use, don't drop
them.  Just apply CREATE OR REPLACE FUNCTION.  This avoids breaking
cached plans that refer to the function(s) by OID.

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux