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 1qbkwd-00Cwwd-0c for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Aug 2023 16:54:59 +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 1qbkwb-008dzl-VI for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Aug 2023 16:54:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qbkul-008au6-R6 for pgsql-hackers@lists.postgresql.org; Thu, 31 Aug 2023 16:53:03 +0000 Received: from mail-pl1-x634.google.com ([2607:f8b0:4864:20::634]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qbkui-0020Gz-Hs for pgsql-hackers@postgresql.org; Thu, 31 Aug 2023 16:53:01 +0000 Received: by mail-pl1-x634.google.com with SMTP id d9443c01a7336-1bdf4752c3cso7789435ad.2 for ; Thu, 31 Aug 2023 09:53:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1693500779; x=1694105579; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=thHMVe8/+mstbT4ScaNJsa+VnZfcbfdGLpbF14a4aJc=; b=aw5oCtjR84QwrWIuSEK10u6ZxUPnKidj6id+CzsBjAn4rH8VZBsVj0wdCdFmckdIEO B3rKehO5sIwy/Q1OG9C223LenRRjPpELcTCarXVrdBy5mLCmrnfedNFfbsqsj1Hh5SOc 5odmuUdDnKzdCXJ26fSD9gtDQehr5clFCuAXOCRz8AZKGs/Pu50VteOladYPiWE8h6P/ 7SuYtLKfmh1mYZKDcxJ0dm/CbPC/TFk00COGhTv81xRtlRes7HRtjbN6ICtLji1e68er 0DGBSK3+Lm3KCgJANdcDssej+TtmLovoPt5e9qhvVEYGyv/aHuTgJDQLFf0NovCyekxn Dpew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693500779; x=1694105579; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=thHMVe8/+mstbT4ScaNJsa+VnZfcbfdGLpbF14a4aJc=; b=bm/E1ULOsGkRoSVkh8Zr35A9rcUW0yAAtCWUJtxy0UuVSmWAH5Rf3IssKYynloeFq6 QJpxQXuOgMwAbt1OcVej75L0PE9hkebsNulnFpVo4rbJdoZcNGHmmgJJXh2bv5WkvBDt tJt/7gzlWtSUQtH4USNXPZnF/wTXHRPGXI66PvwH4opOP4pKELeZ2Hk/sO/BCd6yrtf3 1gBuPTAP0RmydJm23aqhoeHJuGJaJPpa/1OoH8vbVC/miKtN7lFsryflJmUKyzKGMWQL iPdHmG8HKY2vvaiSXtRjeW48hcbIe32as61d83aRbz/Had0Y/jWUNDs96PkudHmkVf4A EwGw== X-Gm-Message-State: AOJu0Yz3qi2Z3LdkprO7SrJIv7ejkb+IOzLlYO/kTs/CrjkP9DpPIcl9 uVojLrtqRxEBv1QntZmPgY/jIq2R5OLr3M/au+4= X-Google-Smtp-Source: AGHT+IHjWaDotJ/xOHUkJkYiE6BxxJytsLBzcnsgMyAxJgOHyspMN0439+9iOrrz50Andw1ahiK2MQ== X-Received: by 2002:a17:903:2347:b0:1c1:f5a6:bdfa with SMTP id c7-20020a170903234700b001c1f5a6bdfamr258919plh.7.1693500779711; Thu, 31 Aug 2023 09:52:59 -0700 (PDT) Received: from jeff-laptop.lan (c-98-45-81-55.hsd1.ca.comcast.net. [98.45.81.55]) by smtp.gmail.com with ESMTPSA id y6-20020a170902ed4600b001bb9f104333sm1480490plb.12.2023.08.31.09.52.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 31 Aug 2023 09:52:59 -0700 (PDT) Message-ID: Subject: Re: [17] CREATE SUBSCRIPTION ... SERVER From: Jeff Davis To: Ashutosh Bapat Cc: pgsql-hackers@postgresql.org Date: Thu, 31 Aug 2023 09:52:59 -0700 In-Reply-To: References: <149ff9264db27cdf724b65709fbbaee4bf316835.camel@j-davis.com> <830a2bc6cbbb2e6e01c6c0d9f31f320822e10603.camel@j-davis.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-08-31 at 10:59 +0530, Ashutosh Bapat wrote: > The server's FDW has to be postgres_fdw. So we have to handle the > awkward dependency between core and postgres_fdw (an extension). That sounds more than just "awkward". I can't think of any precedent for that and it seems to violate the idea of an "extension" entirely. Can you explain more concretely how we might resolve that? Regards, Jeff Davis