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 ) id 1qaasL-009pDm-MP for pgsql-general@arkaria.postgresql.org; Mon, 28 Aug 2023 11:57:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qaasK-00BVis-Cl for pgsql-general@arkaria.postgresql.org; Mon, 28 Aug 2023 11:57:44 +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 ) id 1qaasJ-00BVig-SR for pgsql-general@lists.postgresql.org; Mon, 28 Aug 2023 11:57:43 +0000 Received: from mail-ed1-x535.google.com ([2a00:1450:4864:20::535]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qaasG-001WSq-EX for pgsql-general@postgresql.org; Mon, 28 Aug 2023 11:57:43 +0000 Received: by mail-ed1-x535.google.com with SMTP id 4fb4d7f45d1cf-52889bc61b6so4289801a12.0 for ; Mon, 28 Aug 2023 04:57:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1693223859; x=1693828659; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=fgk2dKzCzR8FktdYZHiCJgYD6skh/8j3MDvtpKz8nLY=; b=Q5nnHrRK681eOZdrv7oapRyPGdMQrjRYN8JmExvcai4zNOrMAxN80P6AgeuBz+4MvB Kwfpq51JdKbywG4e4Dyc9AbHXiPeTrDe54GgU0GkltF6GKMyZvDlEkYlZ6QiiV8AE0zn ygJHt0wykA4jnthx8fe3IdeMhNhdLoD7h6fUJvFyE9dTNI12OVzypGsMbUFniGLl7BGN +Xfw8b++5AZMNKoqxYAbvuv+qDcHdUMkWpWaaOOOglt84zW7Z4Z153DCqGngsUxRM3pr sDBanF33lj6q7IFrit4pZykO96N8V4pvYZCVrc+uh4EDAFYuvNbUXzBRHoytZ1hYinIl UKtw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693223859; x=1693828659; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=fgk2dKzCzR8FktdYZHiCJgYD6skh/8j3MDvtpKz8nLY=; b=THgxFbZJRTOPE4wa4qDFL85y1T/Z9lwPnLBFj1NiTmg1xM0eL+kPsd+4vO0/i49KS8 +jSEJRZOXKs0ZEc64mibeINo6n8ZhGs3cj+OiFwmRa3O0+x2UmheIpyboOlz4tSQ1bO6 ZidF+xffe4gM0wF61breb4eRwYlEIwz+IW/A8nE8zmnmVUvaztB6WOIwqaswdiXVFsKD cvw1UHMdK7iStxj9C+kWbp9O1THjSnFumSvZaDdxYa+mvJQnPcokDNNmas0sc3erTr04 LVgtQvN4EqpS5xSap7tMnMZ0xgPC4WAkqNYK+zhkiStwAEKGNNNA4t6O/IfAYNpHi9mc 3v4g== X-Gm-Message-State: AOJu0YwODoR8zLn3g4qJnK1KOjapyYZtCdU3lI0mjY/DIAtTGzFFnhVs uoljhCowH/ScJHVYDLTBQb9rpg== X-Google-Smtp-Source: AGHT+IEp/nEd5FPYYZoYjYqMFSzfkuo6C+jrCVc7AMa+vQ4Lodi9DBx2G/FBpwhi1Jf/ljxmsDOJWw== X-Received: by 2002:aa7:ca51:0:b0:52a:38c3:1b49 with SMTP id j17-20020aa7ca51000000b0052a38c31b49mr10237420edt.40.1693223858890; Mon, 28 Aug 2023 04:57:38 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:80b2:410f:ff80:3e5c:63bd]) by smtp.gmail.com with ESMTPSA id j26-20020a50ed1a000000b005257f90c976sm4380620eds.3.2023.08.28.04.57.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 28 Aug 2023 04:57:38 -0700 (PDT) Message-ID: <2df60a8f29d4d60ef54e59f7c945f2e5ab0d9a42.camel@cybertec.at> Subject: Re: Support for Deferred Constraints in PG15 Logical Replication From: Laurenz Albe To: Jitesh Srivastava , pgsql-general@postgresql.org Date: Mon, 28 Aug 2023 13:57:37 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2023-08-25 at 00:28 +0200, Jitesh Srivastava wrote: > I'm interested in finding out whether logical replication in PostgreSQL 1= 5 includes support for deferrable unique constraints.=20 You can have deferrable constraints on both ends, yes. If you wonder whether SET CONSTRAINTS ALL DEFERRED is replicated, no, it isn't. Yours, Laurenz Albe