Re: extension dependencies with 'requires'

2018-05-01 Thread Eric Hanson
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

extension dependencies with 'requires'

2018-05-01 Thread Eric Hanson
. 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

Re: I do not get the point of the information_schema

2018-02-14 Thread Eric Hanson
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