From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: grosser.meister.morti@gmx.net
Subject: BUG #18963: Column confupdsetcols missing in pg_catalog.pg_constraint
Date: Thu, 19 Jun 2025 16:33:52 +0000
Message-ID: <18963-4fa37be61361c1d6@postgresql.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, grosser.meister.morti@gmx.net
Subject: Re: BUG #18963: Column confupdsetcols missing in pg_catalog.pg_constraint
In-Reply-To: <18963-4fa37be61361c1d6@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox