Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1rV8VP-00F4hc-I4
	for pgsql-docs@arkaria.postgresql.org; Wed, 31 Jan 2024 11:11:48 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1rV8VO-00DWzl-NL
	for pgsql-docs@arkaria.postgresql.org; Wed, 31 Jan 2024 11:11:46 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <peter@eisentraut.org>)
	id 1rV8VN-00DWza-Pw
	for pgsql-docs@lists.postgresql.org; Wed, 31 Jan 2024 11:11:46 +0000
Received: from fhigh4-smtp.messagingengine.com ([103.168.172.155])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <peter@eisentraut.org>)
	id 1rV8VK-004hNh-LS
	for pgsql-docs@lists.postgresql.org; Wed, 31 Jan 2024 11:11:45 +0000
Received: from compute7.internal (compute7.nyi.internal [10.202.2.48])
	by mailfhigh.nyi.internal (Postfix) with ESMTP id 12E35114009C;
	Wed, 31 Jan 2024 06:11:41 -0500 (EST)
Received: from mailfrontend1 ([10.202.2.162])
  by compute7.internal (MEProxy); Wed, 31 Jan 2024 06:11:41 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org;
	 h=cc:cc:content-transfer-encoding:content-type:content-type
	:date:date:from:from:in-reply-to:in-reply-to:message-id
	:mime-version:references:reply-to:subject:subject:to:to; s=fm2;
	 t=1706699501; x=1706785901; bh=bRpGq3curQVnHtUURAZaw1c/1uxY0/tA
	jEtPm2HV960=; b=GVss2kgnaXrN65KoELQEDDERwJkO9S4aDBpoFHv1JCM73fHd
	fQhpUk31ReBNTYnuntS2YwcKPjzkUWkn3N8WU3o0IWY9+H8f90hnuF2PzozfWEME
	JnxvCtn84T/nFoBW3rALd7J2EPn9l4JE/DZvfBOHRJfz2LMTsgFqhLCYw1cLWJon
	y4PPKOFDpS0+03/teEDiNOIhukWFm8p9PlXqFHFBQKIQrYqoqex+zqqJlxXvZmDu
	B8sW5cDrx2jearpTLTL/YDWUFqQYGC+wgQCmuVn6GuvldGrOPBC3toJf0ZYTlCRB
	usxH7Nca7kqVSkEG3/K/KrsJIo4C4A+MY2EWBA==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-transfer-encoding
	:content-type:content-type:date:date:feedback-id:feedback-id
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1706699501; x=
	1706785901; bh=bRpGq3curQVnHtUURAZaw1c/1uxY0/tAjEtPm2HV960=; b=q
	m8qOEdaiXnkKO/XYyYyYq0Blh/gdupwLvbEumedzC9oCqHOGFJZrQ7x4VR/y2jTc
	rcT7z81gq3dX70k5jeJt4haLc+TMLcdw1/oogcI8otsSCH1H1AZ+1vluHITcifE4
	G/9q82GWnEkFMIUg9HE/47kNa+fEQh113J7lz9fESOKM6K6DqdflEtAy2mSDrNA3
	hTo+23IL5Zn2uMwTbOct4UsfBe4oZcQzD2W6ckbfNJbz/fAJFBNxM+gaccmPH+AF
	6LvPZN+JnhD8pU+jdOi5xFHvwExtyeiLQDz3bR3oLZIqGU5sXnI5TBCu+zWZTyor
	N271PQ71n3S2vp9lEJuxg==
X-ME-Sender: <xms:7Cq6Zc_aQWB0DWS3x3dVa0A5PdyvczCm20YPOsCnMu799EzpYulvVw>
    <xme:7Cq6ZUtAaqdHj1Bs0z9yNv9IFiXrOj3vr9vZqIH_ocgC0JofMTzajNrYI8CwyCVmK
    7D825e7owevK5tTNw>
X-ME-Received: 
 <xmr:7Cq6ZSAahQQ3AF-xdSaW8s8tfC3yPIWZ0CwhU24jCnnPMIaDVXsB6cPDuhTglZ4hgnx7cHHDcV8GVICRwAvwjMZyQGgLDiNh5Q>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgedvkedrfedtledgvdefucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne
    cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpefrvght
    vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvghnthhrrghuthdrohhrgh
    eqnecuggftrfgrthhtvghrnhepgfejtdfhkeeftdeugfeileehteeljeeghfeuledthfeu
    tedvffdukeefjefhgeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg
    hilhhfrhhomhepphgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhg
X-ME-Proxy: <xmx:7Cq6ZcdLiJzTSDkcBEitRenSnZYMJzS61bYDBZdbIKeWofxpzPiNMg>
    <xmx:7Cq6ZRPS1MMJVCOybzPPH-TGoGtQswctc8Ys90V7XlaW_ZF7qR2T5g>
    <xmx:7Cq6ZWkgxTp1vUxuIadDM3oC44us62ZiSiacwGXwD5ecEboRbIYZxw>
    <xmx:7Sq6ZWpvtpE5HOLrpt4pZX6rzBR2uuHtxwltQRXUIuwG7V2KHDHlhg>
Feedback-ID: ie0a040ee:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed,
 31 Jan 2024 06:11:40 -0500 (EST)
Message-ID: <d7b210f3-bb44-4d73-a68a-f8eb51576c8f@eisentraut.org>
Date: Wed, 31 Jan 2024 12:11:38 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: create table explicitly mention that unique|primary key
 constraint will create an
Content-Language: en-US
To: Laurenz Albe <laurenz.albe@cybertec.at>, vignesh C <vignesh21@gmail.com>
Cc: jian he <jian.universality@gmail.com>, pgsql-docs@lists.postgresql.org
References: 
 <CACJufxFG682tYcP9aH_F-jrqq5End8MHZR77zcp1=DUrEsSu1Q@mail.gmail.com>
 <24f01200b651ff87311ae0f46b99eaf91fc3ec43.camel@cybertec.at>
 <f0f2ecbc-3237-4cf7-8fb3-b8eb2b039bf8@eisentraut.org>
 <207308248667f3364423e4c61a84e267e7860c9c.camel@cybertec.at>
 <CALDaNm0=YqFkMSiZO42dEcD2_qa+5Xvfuu+hbYnVQ5ii+c2kfw@mail.gmail.com>
 <8334989d2db6ae58b54d4d43a73e7419aa920e0d.camel@cybertec.at>
From: Peter Eisentraut <peter@eisentraut.org>
In-Reply-To: <8334989d2db6ae58b54d4d43a73e7419aa920e0d.camel@cybertec.at>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/d7b210f3-bb44-4d73-a68a-f8eb51576c8f%40eisentraut.org>
Precedence: bulk

On 26.01.24 16:52, Laurenz Albe wrote:
> On Fri, 2024-01-26 at 19:01 +0530, vignesh C wrote:
>> CFBot shows that the patch does not apply anymore as in [1]:
> 
> There was a conflict with 46a0cd4cefb.
> Updated version attached.

Sprinkled in some of David's suggestions, and pushed.

I was hesitant to burden the user with the difference between "relation" 
and "table" at this point, so I took the former term out of the text.