create table explicitly mention that unique|primary key constraint will create an

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: create table explicitly mention that unique|primary key constraint will create an
Date: 2023-11-27 00:00:00
Message-ID: CACJufxFG682tYcP9aH_F-jrqq5End8MHZR77zcp1=DUrEsSu1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi. minor doc issue.
create table s1(a int, constraint s2 PRIMARY key (a));
create table s2(a int);
ERROR: relation "s2" already exists

https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-PARMS-UNIQUE
maybe for the following 2 sentence
"Adding a unique constraint will automatically create a unique btree
index on the column or group of columns used in the constraint."
"Adding a PRIMARY KEY constraint will automatically create a unique
btree index on the column or group of columns used in the constraint."

maybe we can mention that: the unique btree index name will be the
constraint name.
also is "a unique" or "an unique"?
I personally thought this part is obscure.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2023-11-27 02:30:28 Re: create table explicitly mention that unique|primary key constraint will create an
Previous Message PG Doc comments form 2023-11-26 21:41:48 Table-space documentation