pgsql: Repair misbehavior with duplicate entries in FK SET column lists

2025-04-04 Thread Tom Lane
Repair misbehavior with duplicate entries in FK SET column lists. Since v15 we've had an option to apply a foreign key constraint's ON DELETE SET DEFAULT or SET NULL action to just some of the referencing columns. There was not a check for duplicate entries in the list of columns-to-set, though.

pgsql: Repair misbehavior with duplicate entries in FK SET column lists

2025-04-04 Thread Tom Lane
Repair misbehavior with duplicate entries in FK SET column lists. Since v15 we've had an option to apply a foreign key constraint's ON DELETE SET DEFAULT or SET NULL action to just some of the referencing columns. There was not a check for duplicate entries in the list of columns-to-set, though.

pgsql: Repair misbehavior with duplicate entries in FK SET column lists

2025-04-04 Thread Tom Lane
Repair misbehavior with duplicate entries in FK SET column lists. Since v15 we've had an option to apply a foreign key constraint's ON DELETE SET DEFAULT or SET NULL action to just some of the referencing columns. There was not a check for duplicate entries in the list of columns-to-set, though.

pgsql: Repair misbehavior with duplicate entries in FK SET column lists

2025-04-04 Thread Tom Lane
Repair misbehavior with duplicate entries in FK SET column lists. Since v15 we've had an option to apply a foreign key constraint's ON DELETE SET DEFAULT or SET NULL action to just some of the referencing columns. There was not a check for duplicate entries in the list of columns-to-set, though.