postgres.git / summary / log / commit / refs

commit    fc44ae215fcb1ca88c7cd0c64ffe812fbaba9a37
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Thu Apr 10 18:49:10 2025 +0000
First released in: 18.0, 13.21, 14.18, 15.13, 16.9, 17.5

    Doc: remove long-obsolete advice about generated constraint names.
    
    It's been twenty years since we generated constraint names that
    look like "$N".  So this advice about double-quoting such names
    is well past its sell-by date, and now it merely seems confusing.
    
    Reported-by: Yaroslav Saburov <y.saburov@gmail.com>
    Author: "David G. Johnston" <david.g.johnston@gmail.com>
    Discussion: https://postgr.es/m/174393459040.678.17810152410419444783@wrigleys.postgresql.org
    Backpatch-through: 13


 doc/src/sgml/ddl.sgml | 3 ---
 1 file changed, 3 deletions(-)

diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index dd00bbdaa79..38ece3f4f72 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -1542,9 +1542,6 @@ ALTER TABLE products ALTER COLUMN product_no SET NOT NULL;
 <programlisting>
 ALTER TABLE products DROP CONSTRAINT some_name;
 </programlisting>
-    (If you are dealing with a generated constraint name like <literal>$2</literal>,
-    don't forget that you'll need to double-quote it to make it a valid
-    identifier.)
    </para>
 
    <para>


[parent: 9f21be08e884]