Horton

generated constraint name

The Post Office <noreply@postgresql.org>

View thread View on postgr.es
From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: y.saburov@gmail.com
Date: 2025-04-06T10:16:30Z
Lists: pgsql-docs 
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/ddl-alter.html
Description:

url:
https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-REMOVING-A-CONSTRAINT

(If you are dealing with a generated constraint name like $2, don't forget
that you'll need to double-quote it to make it a valid identifier.)

If I have a constraint with the name $2, are there other constraints with
names $1, $3 ... ?

Commits

  1. doc: Small example improvement

  2. Doc: remove long-obsolete advice about generated constraint names.