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 1l4As4-0000ZG-FW for pgsql-admin@arkaria.postgresql.org; Mon, 25 Jan 2021 23:02:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l4As3-0006g4-En for pgsql-admin@arkaria.postgresql.org; Mon, 25 Jan 2021 23:02:07 +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 1l4As3-0006fw-5C for pgsql-admin@lists.postgresql.org; Mon, 25 Jan 2021 23:02:07 +0000 Received: from mail-oi1-x22d.google.com ([2607:f8b0:4864:20::22d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l4As1-0007Wa-5e for pgsql-admin@lists.postgresql.org; Mon, 25 Jan 2021 23:02:06 +0000 Received: by mail-oi1-x22d.google.com with SMTP id i25so5179772oie.10 for ; Mon, 25 Jan 2021 15:02:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=Qmo5vxPaArse0yR+PF/0YWxSipe5mbJRmLrP8dwFHjE=; b=qErx8YAFE2a84/u0o5QbvHRoHgE3HpW7YwxzMQoSpQaYstKMUO8g7xgVBgYk2HeubI 3rss3wJ70K6FcJwF/wtRITRyXuEd0KGsg28Qz0UkFaXgXv6sRF0r3AaxgBSUFj8HNqwy XAKn+D8Itbt7eeAZMHq313p1ik3G4PwsN7bT3jsF/qavjbCIfIV1+8Z/MWx//oRt+P3l /C4TlHwpVYnwal7aWtfd0+d9jU0llWjmgUhcdfz6c1BFVia7ks7Tw0z3LbI50qwipcxf EAQ+XKu4yY99M6//b8I4GNKQq1nO5S+K4qvnrwS6lyUKg/iUZ9eu6YbmdIloByt5wi49 Z45Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=Qmo5vxPaArse0yR+PF/0YWxSipe5mbJRmLrP8dwFHjE=; b=obVXgDgg+SG3IxdfGMhY4x2ouF7Db37zrGH41DcTlfW5MyjqFIIiQewF1jFg9tKUjv LzOytq/1KUEh77mXzrw3+uDykvypgEC2JVTTRew3YcX5B0FchPHkR+pljG/klBIr6356 UPt+vlqpzN+7FW8pWRsO/XuJOF8nHYy96pUTmNPXai97dpx875hQA5jWS6xrv+5VB8Aq 8zkEhF8sQ/RA5o6tEjMMKDAUt9nGQKOe5dAnFOAiRFLWFglZO7GfSyDZyjKMzA6X7x4P uqHSoDo3/2NEdgux5rh7RCup6jqrH2FrxmjkTAhK+XshtzJDEBqCKoY78reqrXORtowe mFIQ== X-Gm-Message-State: AOAM530YHZcq/ZtOJwmAi4rVDDjpc3GOn/ZyP7bpjf6wo1BdvSTsWya+ s0cLCCMc+ECLiTZ50Ktp5pxeKXyxUcvAxw== X-Google-Smtp-Source: ABdhPJxqKDV5OFl+d/IT9AHFVmwUhGbQwqt/iLpzTZ3j4d5NTvT72F7ogAYQKK9+vByY//hUyeDYyQ== X-Received: by 2002:aca:eac4:: with SMTP id i187mr1483371oih.147.1611615724376; Mon, 25 Jan 2021 15:02:04 -0800 (PST) Received: from [192.168.88.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id r2sm3762555oie.1.2021.01.25.15.02.03 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 25 Jan 2021 15:02:03 -0800 (PST) Subject: Re: Unique constraint across all partitions? To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <3d00c1f4-646c-59b7-e4dc-1d51190d2139@gmail.com> Date: Mon, 25 Jan 2021 17:02:02 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 1/25/21 4:44 PM, S Bob wrote: > All; > > > Is it possible to enforce a unique constraint across all partitions for > either declarative or inheritance based partitioning? Preferably > declarative based. You can create unique indexes on parent tables.  Or am I misunderstanding you? -- Angular momentum makes the world go 'round.