Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNQFn-0007jR-Qo for pgsql-bugs@arkaria.postgresql.org; Wed, 30 Sep 2020 00:45:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kNQFm-0003TS-Ow for pgsql-bugs@arkaria.postgresql.org; Wed, 30 Sep 2020 00:45:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNQFm-0003TL-JM for pgsql-bugs@lists.postgresql.org; Wed, 30 Sep 2020 00:45:54 +0000 Received: from sonic301-30.consmr.mail.ne1.yahoo.com ([66.163.184.199]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kNQFi-0008ED-Da for pgsql-bugs@postgresql.org; Wed, 30 Sep 2020 00:45:54 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1601426748; bh=vo4kF0uJ4ZQQaGGrK9R8fUu2Slwam2/Mqvrndz+9Ubg=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject; b=Jh0K5cFttWnqcG8ssvYGJH4iFV28Zhe+I+1vZyjDdC75qOPEtBoVSXmig/KT72lzu0Zd8fsZTMZxZSqS30h9H11H6a4MGUiKM3y3W2q5jyxfd3F18lmxC0NLusiWAGGnexb7TOWCQhKL/6f/JAYDkL4DpRa7dyEt8m36n843vE9bQEU7Si9P+yjA/M7F6cuzz/R5bhLlAzkt1nofbiGbBkJs4p2h39W8wPZNiugStMzgXKxunIPbRRqDRhywQL0m2nBTMMKrPhXCp9PP2tUmoRzBWw1CUXdHW4Ea2ObnszqYjr+1XIh3gncFuBvUR9UuVjoAE5mU6ZpyqwpSs4BxjA== X-YMail-OSG: fZnboSMVM1l4dD2u9NAZUNPDnFF_zY0eYVh5Gk_t36Hmj61PV_zQss7NTfQnrmJ YiC3wm9A3TMJctqOvuouGAlw2ZwB0BZjN1ypAshYwTIC8mhVc6AySgIqgkoUaN4dap94qk8.8Swc HuNyq8suPGNLje.Lk0ljA.FRt.LMPkhp18cd.F.uhzKUQBEnYS_hzmB606n7WaM3kD.Pilezd1eE sugpil0dreOEhn6Kuy.mU8dwkKb51yUYgFsW_mtEh1e.LZtpDFFnU93T33hb.K6GPIoOOcaXMGyw SV0iujvOAUEDIH.uf0WnvtolOkurMrEX.magwiXnhR5oSmHp02TLPJ_cN7pjG9_yxKd9Qt7AYu5H N4299y52iOs5i_1EjGFFS1vpn.pOoHeF.dYVU1UbcnPuchQysw9ER2a1unJTRtp_8lDLzzeGy3oN QVMTrSx.jmxIrt59wVgoiKUUdUxBlTNq.OiFg1E3aCrXF7Ef4rmwaosZqQTwTZ1i8FpDOlTpz_Pg dyI419acf3tj86CKR0xwfO1vNsWYJmt6GlasDYZm2IIpq4m4Mkvj_zS5aAQDDzJbg3zT2VoqBFLo PjRH1r3w13BX.WAa7Fhw5GUQUmrnIQY9ulh3BKvjudXbftgz8BQvMPBo64Ewh.L9ulwZsJhIFLlX GwNJEa9v6ras8k4tZQNYUd8yTiXzcdz_5HpJTf40uqYKku81Qt3QrgXJ.MdJbq4ohTOmQn0UQfEA VfIxm5RzDeTFU53QmIEiRV7Czp0ErZqRGkvyN.DpjHrAJNhl.2Ut9hVhNGrN6Nywy21W.bDra.U2 HxFfZTKDIJBkg2YW6VO7_bV32Vf_ZlpUJ_DdKgvSuObF0zuemr4tMcjBQkvagPGyf60h9EzmCc4d 6zYcXfZM8vgvmY4_.WsvhWVTnpaXV1tx2.dtd32.2z6rHX.rdvRZcgYi6sVLxfVXEEN..fgtrP9T ukqgTGFDguERE7KJ7tShtBMVLztBVMV3nGEs74sjPSRPYfzGrA8WBUMpaP6iUiuPjGvquR7WKdjF 52KBRxknR84qSFY8FflCIR3_vxlwmqPVgqxDcXL.Otdg.gejuiFNQ8CAx4wwT7dhto.1KXEINrF7 wWiA1NxSjdmAjq9Rb7bnw8neqbS6I6Pq0BMZVqRI_hBqNayRtpbAMXbe5g8ri0v.ZT7M5OAqsLzJ F_x3_L5ftagS.L2EgEEbpBoDPQ.tE3elq8r..fRB_hBxLxHkdHcQff3fI46EOjLPVpxdcGgq9fii vvR29NMjbzWkObXbZRk5e8y7HbGo9FpllSeMM4DWBJASn61hcu9BiKHAMGfbvKd0obrCEAwvS5uT qkvmH5wPV7_3H.fs4dcuj1btDDaY0z1FnC2geAkyNIyndJ4ndAMgB5wTsX5j931_itz1ap3UNmUS chDoCXDWF5x1rffaQKpuM7DNI9V4oPsnn5yxDH4CWfcACrO2E86O1XemueDPzbw4uW9h0XWfshUO QaPQm9jrdfkw9Z9J6rx4- Received: from sonic.gate.mail.ne1.yahoo.com by sonic301.consmr.mail.ne1.yahoo.com with HTTP; Wed, 30 Sep 2020 00:45:48 +0000 Date: Wed, 30 Sep 2020 00:45:45 +0000 (UTC) From: Nagaraj Raj To: Tom Lane , David Rowley Cc: Alvaro Herrera , Pg Bugs Message-ID: <1911618289.142880.1601426745079@mail.yahoo.com> In-Reply-To: References: <20200929232225.GA16296@alvherre.pgsql> <796569.1601424405@sss.pgh.pa.us> Subject: Re: ERROR: insufficient columns in the PRIMARY KEY constraint definition MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_142879_1640262838.1601426745078" X-Mailer: WebService/1.1.16718 YMailNorrin Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36 Content-Length: 2447 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_142879_1640262838.1601426745078 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Noted, thank you all.=C2=A0 On Tuesday, September 29, 2020, 05:12:40 PM PDT, David Rowley wrote: =20 =20 On Wed, 30 Sep 2020 at 13:06, Tom Lane wrote: > > Alvaro Herrera writes: > > Here's the proposed error message fix, using the wording that saves > > $1.99.=C2=A0 I agree that trying to cram the constraint type in the pri= mary > > message is uglier. > > WFM. Looks good to me too. David =20 ------=_Part_142879_1640262838.1601426745078 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Noted, thank you all. 

On Tuesday, September 29, 2020, 05:12:40 PM PDT, David Rowley <dgrowleyml@gmail.com> wrote:


On Wed, 30 Sep 2020 at 13:06, Tom Lane <tgl@sss.pgh.pa.us> wrote:

>
> Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> > Here's the proposed error message fix, using the wording that saves
> > $1.99.  I agree that trying to cram the constraint type in the primary
> > message is uglier.
>
> WFM.


Looks good to me too.

David



------=_Part_142879_1640262838.1601426745078--