Working with partition tables - Mailing list pgsql-admin

From John Scalia
Subject Working with partition tables
Date
Msg-id CB597D75-DE77-4D17-9180-E7119AB6AA4F@gmail.com
Whole thread Raw
Responses Re: Working with partition tables
List 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
detachedfrom 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,
dropthe 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


pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Save failed records into auxiliary table
Next
From: "David G. Johnston"
Date:
Subject: Re: Working with partition tables