Re: Wrong note in the information schema section?

 
On Monday, August 30, 2021, David G. Johnston  wrote:
On Monday, August 30, 2021, Daniel Westermann (DWE)  wrote:

>>>Practically speaking there must be some level of scope where a duplicate name error can occur.  All the docs say is that the schema >>>scope is not it.  You've demonstrated that it is the table scope where duplication of names is detected.

>>Thanks, David. The sentence above is still misleading, at least according to my understanding.

>Create a second table and add a constraint of the same name to it.
 

>And your error is actually because the name of the unique index backing the constraint is a problem, not the name of the constraint >itself.  Try naming a check constraint.

Thanks, now it makes sense:

postgres=# create table t1 ( a int );
CREATE TABLE
postgres=# create table t2 ( a int );
CREATE TABLE
postgres=# alter table t1 add constraint chk1 check ( a > 1 );
ALTER TABLE
postgres=# alter table t2 add constraint chk1 check ( a > 1 );


Regards
Daniel