Re: Partitioned tables and [un]loggedness - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: Partitioned tables and [un]loggedness
Date
Msg-id ZtZn0-JVQuBUbpWw@nathan
Whole thread Raw
In response to Re: Partitioned tables and [un]loggedness  (Nathan Bossart <nathandbossart@gmail.com>)
List pgsql-hackers
On Tue, Sep 03, 2024 at 09:22:58AM +0900, Michael Paquier wrote:
> On Thu, Aug 29, 2024 at 09:49:44AM -0500, Nathan Bossart wrote:
>> IMHO continuing to allow partitioned tables to be marked UNLOGGED just
>> preserves the illusion that it does something.  An ERROR could help dispel
>> that misconception.
> 
> Okay.  This is going to be disruptive if we do nothing about pg_dump,
> unfortunately.  How about tweaking dumpTableSchema() so as we'd never
> issue UNLOGGED for a partitioned table?  We could filter that out as
> there is tbinfo->relkind.

That's roughly what I had in mind.

-- 
nathan



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Improving tracking/processing of buildfarm test failures
Next
From: Tender Wang
Date:
Subject: Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails