BUG #18963: Column confupdsetcols missing in pg_catalog.pg_constraint
PG Bug reporting form <noreply@postgresql.org>
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: grosser.meister.morti@gmx.net
Date: 2025-06-19T16:33:52Z
Lists: pgsql-bugs
The following bug has been logged on the website: Bug reference: 18963 Logged by: Mathias Panzenböck Email address: grosser.meister.morti@gmx.net PostgreSQL version: 17.0 Operating system: Linux Description: Foreign key constraints have the option to list the columns that should be changed in ON DELETE/ON UPDATE SET NULL/SET DEFAULT. For the ON DELETE case these columns can be inspected with pg_catalog.pg_constraint.confdelsetcols, but there is no such column for the ON UPDATE case. Is this an oversight? There are also other constraint parameters that I couldn't find (NULLS DISTINCT for UNIQUE constraints and index_parametrs for several kind of constraints), but I haven't searched too long for those yet.