Postgres Pro
Downloads
Home   >   mailing lists

BUG #15954: Unable to alter partitioned table to set logged - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15954: Unable to alter partitioned table to set logged
Date
Msg-id 15954-b61523bed4b110c4@postgresql.org
Whole thread Raw
Responses Re: BUG #15954: Unable to alter partitioned table to set logged  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      15954
Logged by:          Efrain Berdecia
Email address:      ejberdecia@yahoo.com
PostgreSQL version: 11.1
Operating system:   Centos7
Description:

I have a partition table that I created unlogged. I'm using pg_partman to
manage the partition. I then proceeded to load data into it with a COPY
command.

Afterwards, I ran an alter table set logged on the parent table but the
table still shows as UNLOGGED along with all its children.

Is this broken?

I'm running pg11.1

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: BUG #15949: pg_basebackup failed(PG-12-Beta3)
Next
From: Tom Lane
Date:
Subject: Re: BUG #15946: "duplicate key" error on ANALYZE of table partitions in transaction