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 1qbp2n-00D73w-LL for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Aug 2023 21:17:37 +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 1qbp2l-009rqC-BJ for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Aug 2023 21:17:35 +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 1qbp2k-009rq4-KF for pgsql-hackers@lists.postgresql.org; Thu, 31 Aug 2023 21:17:34 +0000 Received: from mail-oa1-x2b.google.com ([2001:4860:4864:20::2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qbp2h-0022G4-4R for pgsql-hackers@postgresql.org; Thu, 31 Aug 2023 21:17:32 +0000 Received: by mail-oa1-x2b.google.com with SMTP id 586e51a60fabf-1c8d895a602so786610fac.2 for ; Thu, 31 Aug 2023 14:17:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; t=1693516650; x=1694121450; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=pIXfBJXjFaUrwomWzrhcppzQCH+9CWBPJXSpVGun2sQ=; b=Cww40AHCAIfm3TNXBn2F6SXo7yIoUU9pL757E7iEoU4vCnhZo2Z+6uSMmfToEFGpQP P4IA5JE4znsVvIku+tRduA3gtW2g8zZUGrdd/03IvNNcrJ+KRx8bSFjBBANAVaq0e7au nNPMxXeibCLpaRSL3RS16soV05mlhyjVFTCjUKYehtZCU820qvWYdJH0BsTQXD/HvP0T MqzeBg7vnTKwvJL1tiqZ+xl61KOB0OJo1CoqLNAW2MxdFjeduilDPYaZ/56IZFot6P6C y2mhTctRAwtLTsMPVYKyCSaMuPaTUN1DudcXwUCmukHR3OJcnMrFt6ajG1cOkQP0dI5B zwOQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693516650; x=1694121450; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=pIXfBJXjFaUrwomWzrhcppzQCH+9CWBPJXSpVGun2sQ=; b=UuTYzf05khfAfVX73h5i5pIhtMhrmWIh3T6IwlilKL9IosMir3xinOtxcDw2MJzRcG F7facu8gHH7uYH2u21ELPDPfXU4aCfpZEethpZeio6E1bh2ibOVh0iBlx+WImO1lLZVM 6deFYr4Cw6CLAxEfNOrLJpUbq4aUWgTFOKIVIvsETAePof7WeZoghS7ueMH3kgR4ns8Y BKjNoIYbJzPEgNgx4YsWSicpHbfdVW2+nNNNaBp+56I1Bx4BWxGniD9wk+n4jev9B0Eg M07z+/CFV+YKpnLN2fav/NhsPy6QhtCVeVM3y7oMtz0zQ0ovKJzLOv/J2WM3QRDzfHvk 28Lg== X-Gm-Message-State: AOJu0YxVF+zQJljVyDbK2XgFpbEb4GaTIjXNwn+V6X8MvRGnmwNlLviE GIO6v3xPv1saq8a+1RBJ0B3d6A== X-Google-Smtp-Source: AGHT+IFlpaOAfASexCq4zEEgnAnnuPxM8SMrdW0km2TulmAJPaSijc0/HFTONXv3lGhxUJ6eKxDpLA== X-Received: by 2002:a05:6871:88b:b0:1bf:fd8a:826e with SMTP id r11-20020a056871088b00b001bffd8a826emr576168oaq.55.1693516650150; Thu, 31 Aug 2023 14:17:30 -0700 (PDT) Received: from [192.168.4.41] (162-239-31-113.lightspeed.dybhfl.sbcglobal.net. [162.239.31.113]) by smtp.gmail.com with ESMTPSA id u130-20020a818488000000b00565271801b6sm677623ywf.59.2023.08.31.14.17.29 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 31 Aug 2023 14:17:29 -0700 (PDT) Message-ID: Date: Thu, 31 Aug 2023 17:17:29 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: [17] CREATE SUBSCRIPTION ... SERVER Content-Language: en-US To: Jeff Davis , Ashutosh Bapat Cc: pgsql-hackers@postgresql.org References: <149ff9264db27cdf724b65709fbbaee4bf316835.camel@j-davis.com> <830a2bc6cbbb2e6e01c6c0d9f31f320822e10603.camel@j-davis.com> From: Joe Conway In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 8/31/23 12:52, Jeff Davis wrote: > 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? Maybe move postgres_fdw to be a first class built in feature instead of an extension? -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com