diff options
| author | Daniel Gustafsson <dgustafsson@postgresql.org> | 2023-02-24 11:09:50 +0100 |
|---|---|---|
| committer | Daniel Gustafsson <dgustafsson@postgresql.org> | 2023-02-24 11:09:50 +0100 |
| commit | d9595232579a3a9fadf4ce0b4cd58c1a3fc3b2f7 (patch) | |
| tree | 4227113f54ca0385fc9a00046b81c099f004808f /src/backend/utils/adt/pg_locale.c | |
| parent | 94851e4b905042de559d073b6590039ab4598c7c (diff) | |
| download | postgresql-d9595232579a3a9fadf4ce0b4cd58c1a3fc3b2f7.tar.gz postgresql-d9595232579a3a9fadf4ce0b4cd58c1a3fc3b2f7.zip | |
Disallow NULLS NOT DISTINCT indexes for primary keys
A unique index which is created with non-distinct NULLS cannot be
used for backing a primary key constraint. Make sure to disallow
such table alterations and teach pg_dump to drop the non-distinct
NULLS clause on indexes where this has been set.
Bug: 17720
Reported-by: Reiner Peterke <zedaardv@drizzle.com>
Reviewed-by: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://postgr.es/m/17720-dab8ee0fa85d316d@postgresql.org
Diffstat (limited to 'src/backend/utils/adt/pg_locale.c')
0 files changed, 0 insertions, 0 deletions