From: Michael Paquier <michael@paquier.xyz>
To: David Rowley <david.rowley@2ndquadrant.com>
Cc: Amit Langote <amitlangote09@gmail.com>
Cc: ejberdecia@yahoo.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #15954: Unable to alter partitioned table to set logged
Date: Wed, 14 Aug 2019 11:48:22 +0900
Message-ID: <20190814024822.GC14446@paquier.xyz> (raw)
In-Reply-To: <CAKJS1f8wUtYNh3KLrOB=+r6Bio-vUeeS_jyisumz_5V0yok_Pg@mail.gmail.com>
References: <15954-b61523bed4b110c4@postgresql.org>
<CA+HiwqFLG=vN3-H3+Xk2ef_iicnoUtA7tNeZfX7JJc7mGJVZ0w@mail.gmail.com>
<CAKJS1f8wUtYNh3KLrOB=+r6Bio-vUeeS_jyisumz_5V0yok_Pg@mail.gmail.com>
On Wed, Aug 14, 2019 at 01:57:26PM +1200, David Rowley wrote:
> I'd say it's broken in a sense that we can create an unlogged
> partitioned table in the first place. I think that should have been
> blocked.
I don't think that it is that crazy to be able to define a partitioned
table as unlogged, assuming that we could use that to make the
children inherit the same state. We don't allow a mix of temporary
tables and permanent tables as temp table's state does not persist
after the session ends leading to a mess with dependency handling for
the partition tree, but we cannot have that problem with unlogged
tables.
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: michael@paquier.xyz, david.rowley@2ndquadrant.com, amitlangote09@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15954: Unable to alter partitioned table to set logged
In-Reply-To: <20190814024822.GC14446@paquier.xyz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox