Working with partition tables

From: John Scalia <jayknowsunix(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Working with partition tables
Date: 2020-11-12 16:18:48
Message-ID: CB597D75-DE77-4D17-9180-E7119AB6AA4F@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

We’re having a bit of a problem getting a partitioned table altered. The parent table has two partitions, which we have detached from it. The parent, however, refuses to be altered, as the parent still shows it is partitioned 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 new one to that original name and reattach the partitions?

The docs on this seem a bit unclear on this issue.

Jay
Sent from my iPad

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2020-11-12 16:24:58 Re: Working with partition tables
Previous Message David G. Johnston 2020-11-12 15:26:09 Re: Save failed records into auxiliary table