be installed in two
schemas at the same time. Which ever extension is installed first will
create the dep in the target schema, and then the second extension will try
to install the dep and fail due to it being already installed.
Thanks,
Eric
--
Eric Hanson
CEO, Aquameta Labs
503-929-1073
www.aquameta.com
.
Is there a way to use CREATE EXTENSION ... CASCADE and specify in the
control file which schema the dependencies are installed in? How does the
extension know where to install its dependencies?
Thanks,
Eric
--
Eric Hanson
CEO, Aquameta Labs
503-929-1073
www.aquameta.com
--
-- Eric Hanson CEO
gt;c.attnum = any(v.indkey)
> order by
>c.attnum asc;
>
> An other simpler case.
>
> select
>indexname
> from
>pg_catalog.pg_indexes
> where
>schemaname = 'act'
>and tablename = i_table_name
>and indexname = i_table_name || '_hist';
>
>
> --
> Öffentlicher PGP-Schlüssel:
> http://pgp.mit.edu/pks/lookup?op=get=0xCA167FB0E717AFFC
>
--
-- Eric Hanson CEO, Aquameta 503-929-1073