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

From Keith Fiske
Subject Re: BUG #15954: Unable to alter partitioned table to set logged
Date
Msg-id CAODZiv66MC0Tt=SyhHVEyV2gpuwRb+Oav-t0G_tvtUL4Hxaj+w@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15954: Unable to alter partitioned table to set logged  (Michael Paquier <michael@paquier.xyz>)
List pgsql-bugs


On Wed, Aug 21, 2019 at 9:44 AM Michael Paquier <michael@paquier.xyz> wrote:
On Wed, Aug 21, 2019 at 09:24:38AM -0400, Keith Fiske wrote:
> As the others have stated, I think we just need to get some sort of
> consistent method of handling this. Currently running an ALTER TABLE on the
> parent to change the UNLOGGED state simply does nothing which is not
> intuitive whatsoever. Even if it's just throwing an error saying you cannot
> change this property, that would be better until a more thorough solution
> can be implemented in the future.

One problem with an error is that it may break existing application
code :(
--
Michael


Their application is already broken if it's expecting the property to actually change.

--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com

pgsql-bugs by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: BUG #15954: Unable to alter partitioned table to set logged
Next
From: "Thakur, Jitender"
Date:
Subject: PostgreSQL Not Working