Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oxvM9-0008NX-V1 for pgsql-general@arkaria.postgresql.org; Wed, 23 Nov 2022 19:24:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oxvM8-0003U3-Rh for pgsql-general@arkaria.postgresql.org; Wed, 23 Nov 2022 19:24:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oxvM8-0003Tm-GX for pgsql-general@lists.postgresql.org; Wed, 23 Nov 2022 19:24:24 +0000 Received: from mail-qt1-x836.google.com ([2607:f8b0:4864:20::836]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oxvM2-0001ii-Jd for pgsql-general@lists.postgresql.org; Wed, 23 Nov 2022 19:24:24 +0000 Received: by mail-qt1-x836.google.com with SMTP id fz10so11901893qtb.3 for ; Wed, 23 Nov 2022 11:24:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=oNPiNFAcGUGEdYHWlf9LRDkaL+ofRWgItl/WdLkTxIA=; b=UlWC6w5eMwa0LOHIrkwmClWmHmX0d7uQFOcHZLV0N8nNdo6dNBQJX5MlLzHy6Cumep Ebs9/aK79/5qaX5ZYeaX9oAFSd++wS8twNQaH9Gi7cVjAICU6qrg3QAQTMDN2fM0kk2d K5wUiI471oFSDU7vap5NFnsIyy+SeLSt5Pbu8dG+7VcIyVvzIeAkNkiWJrjkTSaF/dZg MKRtTx3EPGZ7IiA91VgM8e9za1GqQIs/GkzrDOHmlFlDAlXF3O5YB8T8HfTTOPHZu0RB iv1tGck9PvrQnzzhFxgrGyrc05htUEX+w9nE4//ZHqbcJY6eL76sLtZqGlcSlVUHn1aj FJXA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=oNPiNFAcGUGEdYHWlf9LRDkaL+ofRWgItl/WdLkTxIA=; b=JyRLHKf9mkwKNIcJ4pAWs9rnskwKH5r7AhTr3ErcU/umcPe7sS5fYhadGrPVLKOGTJ Rqc5IyXJyzOeGCD0iglDkwWiN2j+q7+78Y+3ofElDtxyh+zGkd2o3LLbZ3SgzoWPI0PJ MQSCL5dQPce+TROxHc4eCvTSLnIEsHVjkdJy1jnSHAVQQn5mvHgLX/VEF1jOlaxerWN4 V3acX3NzjrEd3g5zRTprUVVJf6QaAMucXY2imtAY9/IYxxvJ4xNLlZGUBDZ4/vf0vpLC oXpPhBCndrGwQzixNLqhtVD97hc4Pcoi+f3HIEKi3Hp+7TNYnle5vz3/3wIUpkrA2jPD nJKA== X-Gm-Message-State: ANoB5pmR8BvM3O84RiAhzi/cCR7lvqTATBN8NoB0SYTzBUEIoH1s9Lfr j6ESIcqbt94wcO228SqmyZvtuZQL+/A= X-Google-Smtp-Source: AA0mqf477Sg76u/R+sIDO+NYmRn7VKZuIhxlyUQVv6sUqloi+DCLhgvIWU4EAMk/YMmno3uuz5D15w== X-Received: by 2002:a05:622a:251b:b0:3a5:2bad:57f3 with SMTP id cm27-20020a05622a251b00b003a52bad57f3mr27754171qtb.189.1669231456677; Wed, 23 Nov 2022 11:24:16 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::43? ([2600:1700:bd2c:b810::43]) by smtp.googlemail.com with ESMTPSA id i5-20020a05620a404500b006fb11eee465sm12716359qko.64.2022.11.23.11.24.15 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 23 Nov 2022 11:24:16 -0800 (PST) Message-ID: <8a298271-3643-4298-ee19-ed219a5ca7af@gmail.com> Date: Wed, 23 Nov 2022 13:24:15 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: table inheritance partition and indexes Content-Language: en-US To: pgsql-general@lists.postgresql.org References: From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Out of curiosity, why INHERITS in v13 instead of PARTITION BY? On 11/23/22 09:31, Ted Toth wrote: > I've created a table with a number of indexes and then created a partition > table that inherits from it using "CREATE TABLE... INHERITS..." . I've > then queried pg_indexes on the parent for its indexes and tried creating > matching indexes on the child and attaching them to the parent table > indexes. However "ALTER TABLE ... ATTACH PARTITION ..." is returning the > error " is not a table partitioned index". I've > followed the inheritance partitioning example and read the "CREATE INDEX" > docs but I must be missing something, can anyone help me understand what > I'm doing wrong? I'm using version 13. > > Ted > -- Angular momentum makes the world go 'round.