diff options
| author | Daniel Gustafsson | 2023-02-24 10:09:50 +0000 |
|---|---|---|
| committer | Daniel Gustafsson | 2023-02-24 10:09:50 +0000 |
| commit | d9595232579a3a9fadf4ce0b4cd58c1a3fc3b2f7 (patch) | |
| tree | 4227113f54ca0385fc9a00046b81c099f004808f /contrib/postgres_fdw | |
| parent | 94851e4b905042de559d073b6590039ab4598c7c (diff) | |
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 'contrib/postgres_fdw')
0 files changed, 0 insertions, 0 deletions