Re: Weirdness using Executor Hooks

On Thu, Jun 18, 2015 at 6:04 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> What we were expecting I guess is that such functions would be declared
> to reference the library underneath $libdir/plugins, not that you'd use
> a symlink.

According to pg_proc.probin, all 32 of my C language functions point
to $libdir/my_extension_lib, which makes sense because as part of the
extension .sql I declare them as LANGUAGE c AS 'MODULE_PATHNAME', and
MODULE_PATHNAME gets substituted by make.

So are you saying that we should instead declare them AS
'$libdir/plugins/my_extension_lib' so that it matches what's happening
in local_preload_libraries? And is it safe to directly update
pg_proc.probin (and ya know, terminate all existing backends)?

Thanks so much for your time!

eric

ps, I think if we just changed our deploy process to terminate
existing backends this would just disappear, yeah?