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 1qc9KP-00E3Eh-Qi for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Sep 2023 18:57:09 +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 1qc9KO-00Gjqf-EC for pgsql-hackers@arkaria.postgresql.org; Fri, 01 Sep 2023 18:57:08 +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 1qc9KO-00GjqP-3j for pgsql-hackers@lists.postgresql.org; Fri, 01 Sep 2023 18:57:07 +0000 Received: from mail-pl1-x631.google.com ([2607:f8b0:4864:20::631]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qc9KL-002Oiy-BW for pgsql-hackers@postgresql.org; Fri, 01 Sep 2023 18:57:07 +0000 Received: by mail-pl1-x631.google.com with SMTP id d9443c01a7336-1bdca7cc28dso19223435ad.1 for ; Fri, 01 Sep 2023 11:57:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1693594623; x=1694199423; 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=pzmmMAM0wQYF5r36OlyjNm7LDiiLZ+PA34ue8fZFNPA=; b=e5Wvharr0wlFO2INYaNAw5mAIicwNJKN222mILSk6uAGQzXTAiVRl26+BGRCOLoAmY MGJyb0HQyO3M86W/lho+rA1HPiam4dbSCpUZQAyrDU+273OtKJyzmIP+sm9gD61FnT0n sInd4vKNvvGV0BkQGe+tk4SgaBsWo9MBqem3/F2+dU+8mrTJXLLf3bylEJWM8j+o1J+5 fJs5ns5+WJ4mM7PUDXIiL9N6K9wEbtLFZjtDS09vFrd/Isy/IBgKjm/w+APuMzTs/pcq HlEBrDCnFZ8T6+OH2XGPS4P7yCW9Hbq82K2nAK2391gxavhwZVMrnEcjuPGvBc1N/zOR 0P6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693594623; x=1694199423; 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=pzmmMAM0wQYF5r36OlyjNm7LDiiLZ+PA34ue8fZFNPA=; b=VV8MGVEeUpzP22nrp4TvwMSxE20qKP97eAHK5WuJe21zIlaDC/Slmyqjxx0Ye75L3f GwTUFtExg7CpEyvG9Pvpg75CQ7Nqt62yxNbPs0Sn6n8gfoW3dqWbvDDSmiSnssHuBbyG OxCplQpk+Ai+zEkVarhE8dlwHCUdK45YNVgBzCsmJb4qVsI0ggjmkQbU6Bbrv8O8A1NO AkQo1dfUv/bmuvMnBTdy9v54n9GvkrUI/aiU+VVxgRQpSCqIWhB3D7tNpxo8jh5oC7d1 L84oGraqPyCODgvy21+Xac1H77MywTleeNbGDs5o+6Qoi5kCCThpvo85m8j7y+mXvnsN OCbA== X-Gm-Message-State: AOJu0YzRIGaEkOF69NRP7el3MlA4V/5QRzTAX+hrhHvg//yO8wKzWw38 t7LjUGLqirmngpdR6m1sz+1B4A== X-Google-Smtp-Source: AGHT+IEP3Gnz88cJyN4KwC1AycwUIcgWZpbmIMx0S7rWvXJ6lz8ynYHPOm+K9s4+Ythjot1r3+kYfQ== X-Received: by 2002:a17:902:c412:b0:1c0:77b8:bb10 with SMTP id k18-20020a170902c41200b001c077b8bb10mr5422053plk.10.1693594623405; Fri, 01 Sep 2023 11:57:03 -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 17-20020a170902ee5100b001bba1475c92sm3284866plo.113.2023.09.01.11.57.02 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 01 Sep 2023 11:57:03 -0700 (PDT) Message-ID: <63ceeec59ad6c07e17ce280e4bae31b65806ec06.camel@j-davis.com> Subject: Re: [17] CREATE SUBSCRIPTION ... SERVER From: Jeff Davis To: Joe Conway , Ashutosh Bapat Cc: pgsql-hackers@postgresql.org Date: Fri, 01 Sep 2023 11:57:01 -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 17:17 -0400, Joe Conway wrote: > Maybe move postgres_fdw to be a first class built in feature instead > of=20 > an extension? That could make sense, but we still have to solve the problem of how to present a built-in FDW. FDWs don't have a schema, so it can't be inside pg_catalog. So we'd need some special logic somewhere to make pg_dump and psql \dew work as expected, and I'm not quite sure what to do there. Regards, Jeff Davis