Feedback-ID: i0fe9450f:Fastmail
Date: Thu, 25 Apr 2024 08:55:27 +0900
From: Michael Paquier <michael@paquier.xyz>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Nathan Bossart <nathandbossart@gmail.com>,
	Postgres hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Partitioned tables and [un]loggedness
Message-ID: <Zimb7xfc79Har77d@paquier.xyz>
References: <ZiiyGFTBNkqcMQi_@paquier.xyz>
 <20240424202640.GB861150@nathanxps13>
 <CAKFQuwY3RTTrp7x4OmEruMmOghdorhq4=eC0ZfG0NM+HnBWFsw@mail.gmail.com>
 <ZimXRKOSHMjQjAy3@paquier.xyz>
 <CAKFQuwZwMOkw-7112u1-gXEhRWuXiZe9otp801Z3dPVvarKdsA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="xrRZMLeUewiKxM2l"
Content-Disposition: inline
In-Reply-To: <CAKFQuwZwMOkw-7112u1-gXEhRWuXiZe9otp801Z3dPVvarKdsA@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/Zimb7xfc79Har77d%40paquier.xyz>
Precedence: bulk


--xrRZMLeUewiKxM2l
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Apr 24, 2024 at 04:43:58PM -0700, David G. Johnston wrote:
> My point is that if you feel that treating logged as a copy-able property
> is OK then doing the following should also just work:
>=20
> postgres=3D# create temp table parentt ( id integer ) partition by range =
(id);
> CREATE TABLE
> postgres=3D# create table child10t partition of parentt for values from (=
0)
> to (9);
> ERROR:  cannot create a permanent relation as partition of temporary
> relation "parentt"
>=20
> i.e., child10t should be created as a temporary partition under parentt.

Ah, indeed, I've missed your point here.  Lifting the error and
inheriting temporary in this case would make sense.
--
Michael

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

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmYpm+8ACgkQnvQgOdby
QH2CFQ//bGvN0wMyhb2BSWdNB+kOJRAIRJt18ke0yznKcqLQ9zlmwllbpMvaiIvA
pISAl0J7pRN29bzE62r0e2v5R21kN/KKxnzfoY2MyMGU9YLMJWGJ9hA5cGG6lzfG
UW1JFxNNKYwWl2CAVd/hyR98KPCiSvt7XkGWCfb7wMchPaAYgDoLUHVDmt1zyf1a
5DatBA21hrgbcLLM/aF+AQFFbdkdm6S+pTmdqWOic8hTnJ+XDpYUHcuWBcdpgig9
9wK+H2t6HDmEveRmQ7SQ60Adp/N+Tri5NQW+JAxPUL2rZ7OJY+wTkqfU8g395Gsb
zZhUtpiUo9l0bdJssLut5yCpmwPwDvuCx5zlNOZabCSyZa9Cfef2RhApdXGzU2du
m6GhaK3SC3BuH7eFbfDhxW5/VrpcOgYZ0WMqZOvmB7STBgg1LoRY7BVaSHuh2JZk
VmLdyaAHk0VIyytHhaZeznsKcmdZ4kt+NJzGZHxThrvkDLFsAWwHhyTWLOwrPYx8
S3e5C5esIh91JLHLcusf6AHSBQ7sX7xzVj7LmMdWe2TnXege9PeWxa915vI0t9au
DO0VXHGph8FQohx8l050WqSxlZNchHXPpdnwfU2k1yxOS3kNGltkGQpeUBl8MJSw
qGIJjQn388wy1R6rTWkXDOr5UKp4bJA/dWsF6Z3s9POGrbzpDa8=
=L9Wh
-----END PGP SIGNATURE-----

--xrRZMLeUewiKxM2l--