Re: Patch: Global Unique Index

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Vik Fearing <vik(at)postgresfriends(dot)org>, Cary Huang <cary(dot)huang(at)highgo(dot)ca>, Thomas Kellerer <shammat(at)gmx(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Patch: Global Unique Index
Date: 2022-11-29 16:29:04
Message-ID: 26fcfb7700783faa397c712ea9721090958e0e51.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2022-11-29 at 13:58 +0100, Vik Fearing wrote:
> I disagree.  A user does not need to know that a table is partitionned,
> and if the user wants a unique constraint on the table then making them
> type an extra word to get it is just annoying.

Hmm. But if I created a primary key without thinking too hard about it,
only to discover later that dropping old partitions has become a problem,
I would not be too happy either.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2022-11-29 16:29:13 Re: An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication
Previous Message Joe Conway 2022-11-29 16:27:25 Re: Collation version tracking for macOS