From: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This
Date: Mon, 23 Oct 2023 20:18:08 +0300
Message-ID: <2ed04905-a514-4208-a86e-9ae7e4a84a0c@cloud.gatewaynet.com> (raw)
In-Reply-To: <cb59a3a0-78e2-44b0-89d2-a6ceb9f1febe@cloud.gatewaynet.com>
References: <202310231654.g2qqgy7angq2@alvherre.pgsql>
<cb59a3a0-78e2-44b0-89d2-a6ceb9f1febe@cloud.gatewaynet.com>
Στις 23/10/23 19:58, ο/η Achilleas Mantzios έγραψε:
> Στις 23/10/23 19:54, ο/η Alvaro Herrera έγραψε:
>> On 2023-Oct-23, Achilleas Mantzios wrote:
>>
>>> I find PostgreSQL inheritance a great feature. The caveats are the same
>>> since a long time, nothing changed in that regard, but as you say, the
>>> implementation/limitations exist in native table partitioning as well.
>> For partitioning, many of the limitations have actually been fixed.
Seeing here :
https://www.postgresql.org/docs/16/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE
I am seeing the same obstacle to have a global unique index on the whole
partitioned table, without including partition keys of any sort. This is
the same since 11 or 12 IIRC. IMHO the most restrictive limitation. (and
surely too hard to solve)
> sorry that I said that. That's great!
>>
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: a.mantzios@cloud.gatewaynet.com
Subject: Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This
In-Reply-To: <2ed04905-a514-4208-a86e-9ae7e4a84a0c@cloud.gatewaynet.com>
References: <202310231654.g2qqgy7angq2@alvherre.pgsql> <cb59a3a0-78e2-44b0-89d2-a6ceb9f1febe@cloud.gatewaynet.com> <2ed04905-a514-4208-a86e-9ae7e4a84a0c@cloud.gatewaynet.com>
* 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