On 2022-Aug-23, Zhihong Yu wrote:
> A bigger question I have, even with the additional filtering, is what if
> there are multiple constraints ?
> How do we decide which unique / primary key constraint to return ?
>
> Looks like there is no known SQL statements leading to such state, but
> should we consider such possibility ?
I don't think we care, but feel free to experiment and report any
problems. You should be able to have multiple UNIQUE constraints on the
same column, for example.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"Postgres is bloatware by design: it was built to house
PhD theses." (Joey Hellerstein, SIGMOD annual conference 2002)
