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 1uMOPq-00ARAS-Kt for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Jun 2025 09:58:42 +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 1uMOPo-001X6I-By for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Jun 2025 09:58:40 +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 1uMOPo-001X6A-0m for pgsql-hackers@lists.postgresql.org; Tue, 03 Jun 2025 09:58:40 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uMOPk-000CBt-2a for pgsql-hackers@lists.postgresql.org; Tue, 03 Jun 2025 09:58:39 +0000 Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-adb2e9fd208so898907166b.3 for ; Tue, 03 Jun 2025 02:58:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748944716; x=1749549516; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=oOiMbNXXLSVqz3zjMzoTBIHgdB5XBNbDPFMINV1LVbo=; b=G9gQR9DuiOSkvM2uQM1bQBZuuPcjNEP9MQFN5tVl9fezzWwNgMJD61hfh9cVxUoAB+ PE+FXeMV6T1YkYlr0VBOceA2JWMlsQrvYhyuef/cElGpfkEfIfuzzOxIBdUJF9GyY6Jr 6PqjEtz54B9HZatLl3tWHFJUcNgC/wow1YY/9vJ56ExibslNDr7adhOu0rBAtwRv3u25 WWRvp4BvyJGjGs+TRHaDnXvl2mn+g6H67qP76cIfLRX5tOS4npuBSqD5dlrtlmuhMNG/ FUxicNLyDlP1lsXLoriiQn6sjGTB1auXYYd4DZB2/eqetJvsnTAVzDVhzsEvP/d67uTg bewQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748944716; x=1749549516; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=oOiMbNXXLSVqz3zjMzoTBIHgdB5XBNbDPFMINV1LVbo=; b=IKZ82Ho9GcCibJqCapuR5oNWKlFVFYRkrYkm9O3+01h1n9WyDtC3jvKY+sWPKUiztr EeybzEXJhtbcB+gpPOwBNnuXrs7C9f4fn8O/eu3jZi+iudaNdrW6aCwYViX/FCEuMouJ Pw3zZzql2ov7579N6OSGZUPn3CZKehRHT4w2GTZAhU7ZOklfiJm/z4/Yvunr/CkCH0Pa y3OKzvPl0Fk3BZKdwIYA0/hUVSrgkPlMi5LKN+MVD6TKVOTtV5dRypTGaZS/lli2wpkj DBDbmYSGVwIsvQ5gILAtt2Y8Q7/IHvshWxDeAKrAKo+ARJA6VFZOPQ8O5xp5aGjmOwUS gZEA== X-Forwarded-Encrypted: i=1; AJvYcCXlDpE1xUYH6IrH3jIqnTV67AvtnIEf9eyuDo+ODPNU9wPJeM7+yu0li/CTlfEpcFMlQwe+L8+Rtm0N8FvZ@lists.postgresql.org X-Gm-Message-State: AOJu0Yy/jx7PcuZc1YGpij8/4Ss8xwLpU/uuyYvpmntuhagKCsK/EBa9 T7iU3aYYdwnnfvwmoMGIlOIdORh4R+2TDF8xNDGp4UfmvCi+Wi05a7ISsi9bea6yifnFihxQ1xV fvogWXtSeLlaBm/0myegPQ+RZsTUuIkI= X-Gm-Gg: ASbGncs7fkGIQqmoN0x+PYDyNds1MMRZDBkmB4bBTzPnjXeTSkznwTHiHjfjWLgSFdn dNsmUJb0UFMvmArOxIcpaPqybyEQubzWm83KJnaXu98MBEfqvLXbTfBEBZIZCOJ+As4rFuoJY97 aE7FJ/jW8uLMsscHGwk79KK17cf3IFXGn5 X-Google-Smtp-Source: AGHT+IH4Mx6B0oY/o2e6AjqddaJey+TmJi/qFNDCYTieg2y4iPTnATHLonwkHrGV5zyauAX7h1QwkNr0vgUGaXonv4Q= X-Received: by 2002:a17:907:6ea6:b0:ad5:7732:675b with SMTP id a640c23a62f3a-adb3243181bmr1463600666b.40.1748944716011; Tue, 03 Jun 2025 02:58:36 -0700 (PDT) MIME-Version: 1.0 References: <171085360143.2046436.7217841141682511557.pgcf@coridan.postgresql.org> <859476bf-3cb0-455e-b093-b8ab5ef17f0e@postgrespro.ru> <4e2764f7-f6be-478f-8d7f-f921dbd10f5f@postgrespro.ru> <4469cb4d-5820-4cc8-9848-7b9b5934a600@postgrespro.ru> In-Reply-To: From: Alexander Korotkov Date: Tue, 3 Jun 2025 12:58:24 +0300 X-Gm-Features: AX0GCFuZwWOnrjCF6_AdaHxWeDpvX4ZIUCoT5mkGfjjV5Vyf43C5n8ZS2y1_Zn4 Message-ID: Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands To: Dmitry Koval Cc: jian he , pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, May 22, 2025 at 11:57=E2=80=AFAM Dmitry Koval wrote: > > superuser can bypass all permission checks. > > superuser can attach any table to the partitioned table as he wants. > > That's right. > Using SUPERUSER may be a rare situation, but it needs to be processed. I suggest that owner of new partitions produced by ALTER TABLE ... SPLIT should be the same as owner of original partition. Even if this operation is done by superuser. Superuser may explicitly set he owner if needed. I think we need to explicitly document this. ------ Regards, Alexander Korotkov Supabase