Re: ALTER TABLE ... DETACH PARTITION just sitting there

2021-06-28 Thread Laurenz Albe
On Mon, 2021-06-28 at 16:52 -0500, Ron wrote: > On 6/28/21 4:16 PM, Tom Lane wrote: > > Ron writes: > > > AWS RDS Postgresql 12.5. > > > We've got a table partitioned by month range (FOR VALUES FROM > > > ('2011-07-01') > > > TO (2011-08-01')), and I've been detaching partitions from oldest to >

Re: ALTER TABLE ... DETACH PARTITION just sitting there

2021-06-28 Thread Ron
On 6/28/21 4:16 PM, Tom Lane wrote: Ron writes: AWS RDS Postgresql 12.5. We've got a table partitioned by month range (FOR VALUES FROM ('2011-07-01') TO (2011-08-01')), and I've been detaching partitions from oldest to newest, one at a time. Whenever it's failed due to a FK constraint (and ther

Re: ALTER TABLE ... DETACH PARTITION just sitting there

2021-06-28 Thread Alvaro Herrera
On 2021-Jun-28, Ron wrote: > We've got a table partitioned by month range (FOR VALUES FROM ('2011-07-01') > TO (2011-08-01')), and I've been detaching partitions from oldest to newest, > one at a time. Whenever it's failed due to a FK constraint (and there are > many of them!), I dropped the "same

Re: ALTER TABLE ... DETACH PARTITION just sitting there

2021-06-28 Thread Tom Lane
Ron writes: > AWS RDS Postgresql 12.5. > We've got a table partitioned by month range (FOR VALUES FROM ('2011-07-01') > TO (2011-08-01')), and I've been detaching partitions from oldest to newest, > one at a time. Whenever it's failed due to a FK constraint (and there are > many of them!), I d

ALTER TABLE ... DETACH PARTITION just sitting there

2021-06-28 Thread Ron
AWS RDS Postgresql 12.5. We've got a table partitioned by month range (FOR VALUES FROM ('2011-07-01') TO (2011-08-01')), and I've been detaching partitions from oldest to newest, one at a time. Whenever it's failed due to a FK constraint (and there are many of them!), I dropped the "same mon