Re: Extension Templates S03E11

Stephen Frost <sfrost@snowman.net> writes:
> * Dimitri Fontaine (dimitri@2ndQuadrant.fr) wrote:
>> Then as soon as we are able to CREATE EXTENSION mystuff; without ever
>> pre-installing files on the file system as root, then we would like to
>> be able to do just that even with binary modules.

> I really just don't see this as being either particularly useful nor
> feasible within a reasonable amount of effort.  Shared libraries are
> really the perview of the OS packaging system.

Yes, exactly.  What's more, you're going to face huge push-back from
vendors who are concerned about security (which is most of them).
If there were such a feature, it would end up disabled, one way or
another, in a large fraction of installations.  That would make it
impractical to use anyway for most extension authors.  I don't think
it's good project policy to fragment the user base that way.

I'm on board with the notion of an all-in-the-database extension
mechanism for extensions that consist solely of SQL objects.  But
not for ones that need a .so somewhere.
        regards, tom lane