Re: Extensions vs PGXS' MODULE_PATHNAME handling

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> [ scratches head ... ] Why is your version generating so many
> unnecessary @extschema@ uses?

I just ran create table tomlist as select your query and create table
dimlist as select my query, then:

dim=# select * from tomlist except select * from dimlist;
desc
--------------------------------------------------------------------------------------------------
ALTER EXTENSION hstore ADD operator family @extschema(at)(dot)gin_hstore_ops for access method gin;
ALTER EXTENSION hstore ADD operator class @extschema(at)(dot)btree_hstore_ops for access method btree;
ALTER EXTENSION hstore ADD operator family @extschema(at)(dot)hash_hstore_ops for access method hash;
ALTER EXTENSION hstore ADD operator class @extschema(at)(dot)gist_hstore_ops for access method gist;
ALTER EXTENSION hstore ADD operator family @extschema(at)(dot)gist_hstore_ops for access method gist;
ALTER EXTENSION hstore ADD cast from text[] to @extschema(at)(dot)hstore;
ALTER EXTENSION hstore ADD operator class @extschema(at)(dot)gin_hstore_ops for access method gin;
ALTER EXTENSION hstore ADD operator family @extschema(at)(dot)btree_hstore_ops for access method btree;
ALTER EXTENSION hstore ADD operator class @extschema(at)(dot)hash_hstore_ops for access method hash;
(9 rows)

No difference on @extschema@ use here.

dim=# select t.desc, d.desc from tomlist t natural join dimlist d limit 1;
-[ RECORD 1 ]---------------------------------------------
desc | ALTER EXTENSION hstore ADD type @extschema(at)(dot)hstore;
desc | ALTER EXTENSION hstore ADD type @extschema(at)(dot)hstore;

dim=# select t.desc, d.desc from tomlist t natural join dimlist d limit 1 offset 10;
-[ RECORD 1 ]---------------------------------------------------------------------------
desc | ALTER EXTENSION hstore ADD function @extschema(at)(dot)slice(@extschema(at)(dot)hstore,text[]);
desc | ALTER EXTENSION hstore ADD function @extschema(at)(dot)slice(@extschema(at)(dot)hstore,text[]);

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