From: | "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Wrong note in the information schema section? |
Date: | 2021-08-31 06:43:28 |
Message-ID: | ZR0P278MB0920FFE2427CAE3BCD6DC7F0D2CC9@ZR0P278MB0920.CHEP278.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Monday, August 30, 2021, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
On Monday, August 30, 2021, Daniel Westermann (DWE) <daniel(dot)westermann(at)dbi-services(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Pantelis Theodosiou | 2021-08-31 06:51:23 | Re: Wrong note in the information schema section? |
Previous Message | Pantelis Theodosiou | 2021-08-31 06:43:14 | Re: Wrong note in the information schema section? |