On Thu, Jun 18, 2015 at 6:04 PM, Tom Lane <tgl@sss.pgh.pa.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?