Re: MERGE PARTITIONS and DEPENDS ON EXTENSION. - Mailing list pgsql-hackers

From Dmitry Koval
Subject Re: MERGE PARTITIONS and DEPENDS ON EXTENSION.
Date
Msg-id 4401e209-85ac-40ea-a68c-e69e07c0fc49@postgrespro.ru
Whole thread
In response to Re: MERGE PARTITIONS and DEPENDS ON EXTENSION.  ("Matheus Alcantara" <matheusssilv97@gmail.com>)
Responses Re: MERGE PARTITIONS and DEPENDS ON EXTENSION.
List pgsql-hackers
Hi Matheus!

 >v3-0001-Preserve-extension-dependencies-on-indexes-during.patch

I looked patch and did not find problems. But there is one point: 
extensions btree_gist, btree_gin, citext are not included by default.
So command

 > ./configure --enable-debug --enable-cassert --prefix `pwd`/install
 > >/dev/null && make -s && make install -s && make check

generates errors like

ERROR:  extension "btree_gist" is not available
ERROR:  extension "btree_gin" is not available
ERROR:  extension "citext" is not available

Might be it would be better to use for tests extensions from the
catalog src/test/modules/test_extensions (see test
src/test/modules/test_extensions/sql/test_extdepend.sql)?

 >extension dependencies on parent partitioned indexes don't seem to
 >prevent DROP EXTENSION, but dependencies on child partition indexes
 >do. ...

I agree, it looks strange ...


With best regards,
Dmitry Koval

Postgres Professional: http://postgrespro.com



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Add bms_offset_members() function for bitshifting Bitmapsets
Next
From: Peter Smith
Date:
Subject: Re: DOCS - CREATE PUBLICATION ... EXCEPT missing details on ONLY