Tom Lane <[email protected]> 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 @[email protected]_hstore_ops for
access method gin;
ALTER EXTENSION hstore ADD operator class @[email protected]_hstore_ops for
access method btree;
ALTER EXTENSION hstore ADD operator family @[email protected]_hstore_ops for
access method hash;
ALTER EXTENSION hstore ADD operator class @[email protected]_hstore_ops for
access method gist;
ALTER EXTENSION hstore ADD operator family @[email protected]_hstore_ops for
access method gist;
ALTER EXTENSION hstore ADD cast from text[] to @[email protected];
ALTER EXTENSION hstore ADD operator class @[email protected]_hstore_ops for
access method gin;
ALTER EXTENSION hstore ADD operator family @[email protected]_hstore_ops for
access method btree;
ALTER EXTENSION hstore ADD operator class @[email protected]_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 @[email protected];
desc | ALTER EXTENSION hstore ADD type @[email protected];
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
@[email protected](@[email protected],text[]);
desc | ALTER EXTENSION hstore ADD function
@[email protected](@[email protected],text[]);
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
