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 1qIgeW-0002Mh-P2 for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 02:29:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qIgeV-0005xS-K0 for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 02:29:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qIgeV-0005xJ-9t for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 02:29:27 +0000 Received: from rs6162.luxsci.com ([162.142.76.255]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qIgeO-002zTa-Df for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 02:29:25 +0000 Received: from pfortin.com (h231.250.89.75.dynamic.ip.windstream.net [75.89.250.231]) (authenticated bits=0) by rs6162.luxsci.com (8.15.2/8.14.9) with ESMTPSA id 36A2THt2570786 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NOT) for ; Mon, 10 Jul 2023 02:29:18 GMT Date: Sun, 9 Jul 2023 22:29:17 -0400 From: pf@pfortin.com To: pgsql-general@lists.postgresql.org Subject: Re: INSERT UNIQUE row? Message-ID: <20230709222917.0af9a1ac@pfortin.com> In-Reply-To: References: <20230709185807.1bc9afd9.pfortin@pfortin.com> X-Mailer: Claws Mail 4.1.1git47 (GTK 3.24.38; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Lux-Comment: Message 36A2THt2570786 sent by user #22429 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pfortin.com; h=date:from:to:subject:message-id:in-reply-to:references:mime-version:content-type:content-transfer-encoding; s=dkim; bh=dIODoTagFlxBzRUxcU2/LiHv7A68XOiregafUkqLfhE=; b=KYpjrJyljmdyJ/nA6pTcu/g19kUK0SpvVK+airdhKpV301B7pmrRJzrNtpox6jaH1JU7SB1aZNpXGIMMiFm37MUkPJKnRHGUcX442/r4PCMAV7skxotOk9c9oVWmgYQGiKDZWv7jiUJd2ehpyp2wBQgHmaIsOgPixMKy30PGwRc= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 9 Jul 2023 16:42:15 -0700 David G. Johnston wrote: >Yes, the mechanics of defining multi-column unique constraints on tables is >covered in the docs. Good to know I'm not searching in vain...