Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wEc7w-004Cpt-2Q for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Apr 2026 00:04:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wEc7v-00GoxJ-28 for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Apr 2026 00:04:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wEc7v-00Gox4-0g for pgsql-hackers@lists.postgresql.org; Mon, 20 Apr 2026 00:04:35 +0000 Received: from mail.postgrespro.ru ([93.174.132.70]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wEc7s-000000022rq-03GQ for pgsql-hackers@postgresql.org; Mon, 20 Apr 2026 00:04:34 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1776643470; bh=gwNYj6pC8TfDUTXWA7Iml6Z98+Zv+XyKSVrwJ/Dpu2A=; h=Message-ID:Date:User-Agent:Subject:To:References:From:In-Reply-To: From; b=Xplg3W6/x69ilDjk5vBWaN0GFtk0Pev4XbAV1D9pvv7Ovfi0mhdzsbZ+HikADjsUd YXcsNHhlC+Ocsek9jRkjd7aU9bXabuCJquKD5i0X2/G3MKqNn2CvncWmUdlfceAeRU KU/rH9vMpg2J+ydIEmLdIP/bh93XFJ4/PVNoPsv2kRMCojRrlmgUhCt+VPglCJv+xt BJgFUdBru4/sc7cnIYVkK7vYrREDJpoHrSxJ22YsYp3P+2J20HdL9MMWpL592RYXCP UcocgKaxeAyfltvgIu3shZvSS/BaZHYSL2peqwEbnamzGutm6oaJGvnmGy/2z7g963 ajOQ1iChf2Fdw== Received: from [172.30.48.126] (debian11-template.l.postgrespro.ru [192.168.2.254]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (Client did not present a certificate) (Authenticated sender: d.koval@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id 3835961104; Mon, 20 Apr 2026 03:04:30 +0300 (MSK) Message-ID: <4401e209-85ac-40ea-a68c-e69e07c0fc49@postgrespro.ru> Date: Mon, 20 Apr 2026 03:04:28 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: MERGE PARTITIONS and DEPENDS ON EXTENSION. To: Matheus Alcantara , pgsql-hackers References: <31d04a1b-c0cb-4e6f-a344-0db048a3b673@gmail.com> <414c3430-77a9-438e-9dc0-c66033f6be63@postgrespro.ru> Content-Language: en-US From: Dmitry Koval In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-KSMG-AntiPhishing: NotDetected, bases: 2026/04/19 23:46:00 X-KSMG-AntiSpam-Interceptor-Info: not scanned X-KSMG-AntiSpam-Status: not scanned, disabled by settings X-KSMG-AntiVirus: Kaspersky Secure Mail Gateway, version 3.0.0.9059, bases: 2026/04/19 19:33:00 #28418912 X-KSMG-AntiVirus-Status: NotDetected, skipped X-KSMG-LinksScanning: not scanned, disabled by settings X-KSMG-Message-Action: skipped X-KSMG-Rule-ID: 1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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