Date: Wed, 14 Aug 2019 11:48:22 +0900
From: Michael Paquier <michael@paquier.xyz>
To: David Rowley <david.rowley@2ndquadrant.com>
Cc: Amit Langote <amitlangote09@gmail.com>, ejberdecia@yahoo.com,
	PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #15954: Unable to alter partitioned table to set logged
Message-ID: <20190814024822.GC14446@paquier.xyz>
References: <15954-b61523bed4b110c4@postgresql.org>
 <CA+HiwqFLG=vN3-H3+Xk2ef_iicnoUtA7tNeZfX7JJc7mGJVZ0w@mail.gmail.com>
 <CAKJS1f8wUtYNh3KLrOB=+r6Bio-vUeeS_jyisumz_5V0yok_Pg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="2JFBq9zoW8cOFH7v"
Content-Disposition: inline
In-Reply-To: 
 <CAKJS1f8wUtYNh3KLrOB=+r6Bio-vUeeS_jyisumz_5V0yok_Pg@mail.gmail.com>
Precedence: bulk


--2JFBq9zoW8cOFH7v
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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

--2JFBq9zoW8cOFH7v
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl1TdnYACgkQnvQgOdby
QH38zQ/+MyJJCdYe7DxKINohaIXZAf/3BVhCZIbZbXU/ejjtmu3iFNRcXkcQg54i
9Jjn8sHNyHnv+ixF2FRwOmtM0vRkY4vcByZab6ETsIBtlrOjy96xesazjTFTLqVW
NWVo5D4OOtle6YSzHNVLlEluyAwPels94bRw9hOIetq/5nKLtIKReUpKE1ZjdHNi
cNE/f18h7BqJjKZObdSjdePh+PC8AzUHDzqslnkatVOimz5Wl40my9RVvUYABqho
+PX6jtLpvW/XTrnHxWBOm3uO3S/60nBTi3OOPOtgO0K9iScm5s3sFkk/TK1S0b9R
sx5DQRshejDRVNYHiQZj2q+TTU3KmGxoAEMYMrlOOtgsEeP4aXyC7shHdWJLzfLh
sVkpuog34YkFXiSHYzYecfgPnMIJIKaQj+TI9VMzrBH7nHIKuDqYlHw72PP6vcRu
Y5xz5IQf89F3z0aWwZCN/usYFLlEnDpbVbr3SaGxxh1mWG2wDpWgq6HcgPK4AUO9
eRVPtne1/I02ZBIp6MiVOAV7mdSpA0fx/Npm9EwdUV8VpdqnOJBywh+fA8aZrsS2
Id+vmdW+kpGCJhlBgKEw9MIdK9hxd52NxC+S+EW6B4Kbh7NMIhRYdyI8ZtairKrr
lw2uduu3Vu+ZY2eJ2OdhpdWVtrbl2Kp5aLmFOzQT9bX+I+K+nKo=
=uOK1
-----END PGP SIGNATURE-----

--2JFBq9zoW8cOFH7v--