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 1kdFJI-0008TQ-TW for pgsql-admin@arkaria.postgresql.org; Thu, 12 Nov 2020 16:18:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kdFJH-0003RR-S1 for pgsql-admin@arkaria.postgresql.org; Thu, 12 Nov 2020 16:18:55 +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 1kdFJH-0003RI-Hn for pgsql-admin@lists.postgresql.org; Thu, 12 Nov 2020 16:18:55 +0000 Received: from mail-qt1-x82a.google.com ([2607:f8b0:4864:20::82a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kdFJF-0002Ys-G6 for pgsql-admin@postgresql.org; Thu, 12 Nov 2020 16:18:55 +0000 Received: by mail-qt1-x82a.google.com with SMTP id m65so4323455qte.11 for ; Thu, 12 Nov 2020 08:18:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:date:subject:message-id :to; bh=XLAUskl2zPqdaCVyqOu185aWtufPsyVRYHuVeAYiXm4=; b=S7yowoa2nxC88YB7KzwjZ959O9gWX8PW7UraYEjNvtknnna6hFvbsXs6TVse+7m/Vg HOavMK69MxnvzMv0rBYPx+iunHDLV1iynwmUShMOrQAIa9upJYBF3QBBEb9WBGCKUlmd XssVpa8HS/LZbghlQTshEcbIpUhcx6iOt2ReiZMxhxVqsnCtbCt2Oiic1vEupFq/PJC8 WZufUPkmCKYMk5/ZhAuIhtJcu3tA23BKr8XucFhs5Qea2+j9rxpUB8Fg/zN+LdS5PWPl GJL8g0BNy5hQbsVoCwzLh2oz4uLwwqTZ7X6aDSVI2BO4l9IbanC044QKf2jGfESkXRKB 2gHg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version:date :subject:message-id:to; bh=XLAUskl2zPqdaCVyqOu185aWtufPsyVRYHuVeAYiXm4=; b=XhByg4tPcGtlNb8h+pM2SGt2XZnUITV+YAJPz645hD2nDVxfTEPKp9MTHzg9Lde8jC 5/jrdTiL9Wri8+JpE8cdh+t/NYhKzyZKHrIc4FMUuh1we89PQocdyL0Yyr8k6Mq0aFTq pYc30AKsYNMUUn4Oo3f2Ne65F5wubkAYHTq5aELEYlZm6xMzbaJFR6D7M2uIS9FxJVJg yOD0fas093sBf1ZmSWqpXJaORhMf1otbArNwlwMMFXqmAA9uRm1/Nxe+Ly1KndIGonW6 QE3xXBblWEMYa32zxlTnBtvFl9+7rhbPW7S9SpD2lKirtQtsINrcxvS+LaETiIlsTj9j Tv9A== X-Gm-Message-State: AOAM530UVlj53yD8FBcR3rblVzuDmOh+s6HxeYRhwfE+ucmKUc8k/zAn HHovYgUuJUaipNw6ICikulym42JXRdA= X-Google-Smtp-Source: ABdhPJwHsc2yd7yqc1+ym5inqfF4oH/stJlm3mG/9tMu3DmqNC6m9a1iR6ILwXgFsRv+OurYCGZ7Fg== X-Received: by 2002:ac8:3621:: with SMTP id m30mr20175975qtb.168.1605197931140; Thu, 12 Nov 2020 08:18:51 -0800 (PST) Received: from [192.168.254.66] (h217.104.141.67.dynamic.ip.windstream.net. [67.141.104.217]) by smtp.gmail.com with ESMTPSA id v16sm5168835qka.72.2020.11.12.08.18.50 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 12 Nov 2020 08:18:50 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: John Scalia Mime-Version: 1.0 (1.0) Date: Thu, 12 Nov 2020 11:18:48 -0500 Subject: Working with partition tables Message-Id: To: pgsql-admin X-Mailer: iPad Mail (18A8395) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi all, We=E2=80=99re having a bit of a problem getting a partitioned table altered.= The parent table has two partitions, which we have detached from it. The pa= rent, however, refuses to be altered, as the parent still shows it is partit= ioned by its list attribute, I.e. from \d+ Partition key: LIST(batched) Is there any way to remove the partition key, or do we simply need to create= a new table with the structure we need, drop the old one, then rename the n= ew one to that original name and reattach the partitions? The docs on this seem a bit unclear on this issue. =E2=80=94 Jay Sent from my iPad=