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 1mn2we-0007f1-LK for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Nov 2021 18:12:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mn2wd-0006u7-F9 for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Nov 2021 18:12:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mn2wc-0006ty-Ps for pgsql-hackers@lists.postgresql.org; Tue, 16 Nov 2021 18:12:35 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mn2wY-0006YM-BS for pgsql-hackers@postgresql.org; Tue, 16 Nov 2021 18:12:34 +0000 Received: by mail-pl1-x635.google.com with SMTP id y7so18264429plp.0 for ; Tue, 16 Nov 2021 10:12:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=q2PbzlMKdXmqBOHGQ5ByZ6ij5wkiCHtEDgPHEqvZwlM=; b=XiiOKZl4unbNalh8UmHiryG7aYntuJbgAYS+s39g01yHns97IZcSAkows+JRaPSuFU MWS71OLOzOHsh4lNCpNPJ4I9gN222DXgWOfcmXgpZi96YLWUNgzPUBs3taApDPZrcor3 TVxOATl2tkvI25C6sMwdQKYZzUzMvGsQEAnUW1Yn338yPNQDaMPKwtVcjue5hFhsoC0p CfbcGQDxohWN8YMNwXqDgwiTcW3j7WnsFaJVoCZljS4pR0kESUrlWcQk+RScrD7RtRN/ rgVTwO8IVUGiEKM1iqVpu2VvZxpPTAnOSVyx9Hm9gg9ISprumpnZZEygkh02pck04uGO DsCQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=q2PbzlMKdXmqBOHGQ5ByZ6ij5wkiCHtEDgPHEqvZwlM=; b=simpcNQywf4A4xJtQmSLGn5qbb7nPZvqEEOuPiufHwb+8IxfN+udnRVzIzaE6TL4vK 945QXreorJcVQV7bh6nDqfLb/I+buTv/Qh3Od39VMkiBmqMX7x+DTBSsbkX9RNYol6dH mrGll2PaXkfbQVm1MJU4Q0KJb/HMzdiLvBnODmlqMUFyRat0mPZtmVvcQ7CfjN2mXorl FsPvg1KJHum7z0+IRvF1FzQO5Hs1qOxAmbDWi4wxw9Qiv+5jC18W1FsGA/0oo99qhhmi qa6DSgZobvaaY1h/DYRDv4wtib+tfLbTQZ05NCwS4r8XE7lJEeSrSCffwYhltXS/HYxA 2Oaw== X-Gm-Message-State: AOAM5310z45yDVAUpCisFP/lZhoO6YXIW1T8YFPMQ2lXNScVJ20WNfgl RMZbIBcG4s8PdEg/tZDksekTECntJrVMP0CvdQ5Anbesxpg3sA6Mgp9oa9GY9/e0eMQ6R1Ft6uv uLSquCuaHbgb/ysKpIv0aYt3GFnsQ5iiaoDV/4fpTjbDTPXe6wfecEhaTcmYoHU2h1B08s8qWqV +ZFCXe4n9MVoyvmOmRI6IXZCh/iexO5C9j8AhY X-Google-Smtp-Source: ABdhPJzxsC97KIi+mY3LV9o4Xf46sxYmiT/PjyKGIt/OgzxwKmr97bRbaf4psfUkWvTT4sOipB4V1Q== X-Received: by 2002:a17:903:2348:b0:141:d60b:ee90 with SMTP id c8-20020a170903234800b00141d60bee90mr46955677plh.15.1637086347942; Tue, 16 Nov 2021 10:12:27 -0800 (PST) Received: from laptop280-ma-us.hitronhub.home (24-113-193-150.wavecable.com. [24.113.193.150]) by smtp.gmail.com with ESMTPSA id x17sm18571549pfa.209.2021.11.16.10.12.27 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 16 Nov 2021 10:12:27 -0800 (PST) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: Re: Non-superuser subscription owners From: Mark Dilger In-Reply-To: <3c9b220207b8895086887addd37d371ccd1b420b.camel@j-davis.com> Date: Tue, 16 Nov 2021 10:12:26 -0800 Cc: Andrew Dunstan , PostgreSQL-development Content-Transfer-Encoding: quoted-printable Message-Id: <90F401DA-E421-439A-A857-75355A117DB3@enterprisedb.com> References: <9DFC88D3-1300-4DE8-ACBC-4CEF84399A53@enterprisedb.com> <3c9b220207b8895086887addd37d371ccd1b420b.camel@j-davis.com> To: Jeff Davis X-Mailer: Apple Mail (2.3608.120.23.2.7) X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Nov 16, 2021, at 10:08 AM, Jeff Davis wrote: >=20 > On Mon, 2021-11-01 at 10:58 -0700, Mark Dilger wrote: >> It is unclear ..... >>=20 >> Thoughts? >=20 > What if we just say that OWNER TO must be done by a superuser, = changing > from one superuser to another, just like today? That would preserve > backwards compatibility, but people with non-superuser subscriptions > would need to drop/recreate them. The paragraph I wrote on 11/01 and you are responding to is no longer = relevant. The patch submission on 11/03 tackled the problem. Have you = had a chance to take a look at the new design? =E2=80=94 Mark Dilger EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company