Re: transforms

Dimitri Fontaine <dimitri@2ndquadrant.fr>

From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Josh Berkus <josh@agliodbs.com>, pgsql-hackers@postgresql.org
Date: 2013-03-13T16:54:33Z
Lists: pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> At run time, this will sort itself out, because all the required modules
> will be loaded.  The problem is when you create the "glue" extension and
> haven't invoked any code from any of the dependent extension in the
> session.  Abstractly, the possible solutions are either not to check the
> functions when the extension is created (possibly settable by a flag) or
> to somehow force a load of all dependent extensions when the new
> extension is created.  (I say extension here even though dynamically
> loadable modules are attached to functions, which makes this even more
> confusing.)

I think CREATE EXTENSION should be LOADing all distinct modules
referenced from all required extensions functions. It does sound easy
enough to code, and I can't imagine why we would want to not do that.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support