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 1rvKGA-00BG8d-F1 for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Apr 2024 17:00:19 +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 1rvKG9-00GGSF-KP for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Apr 2024 17:00:17 +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 1rvKG9-00GGS7-8Q for pgsql-hackers@lists.postgresql.org; Fri, 12 Apr 2024 17:00:17 +0000 Received: from mail-lf1-x12e.google.com ([2a00:1450:4864:20::12e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rvKG6-002XOj-BO for pgsql-hackers@lists.postgresql.org; Fri, 12 Apr 2024 17:00:16 +0000 Received: by mail-lf1-x12e.google.com with SMTP id 2adb3069b0e04-516cdb21b34so1432161e87.1 for ; Fri, 12 Apr 2024 10:00:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1712941212; x=1713546012; darn=lists.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=WxKP5u29a6/h0HsN0BZtFE+WjVC08hp9oQij2YY8EAw=; b=JvlNNR8L7kL/GbhxMc9C838VqYBB9+Q1heVIwFVuP2vfouN/BtX4n2AYrQQzK7RGWC +F5MTNx6W7/8JEOjv8ABfh94CtBl60nGT/WP8W9+sdJc8asj4kDvuwkX3SmF5Tty+7fS WxyhWYv/NahzleZaR2wfOP/np6/CyADN9R252h1ZXz5fSSmVt7p5wG+dP2q5G8zrZCDx mo57eHxjz0cPXDzoOK7agqgPK+Bp5/s+SYoU9P4v9ehYARPYK7BzXvAGW1S9A0ck8o5w FXW6PHqt0R26yKYoTyOZ0IC3Lkj8suqBnUin9OuMjHoU+h0OHIGC7b3vQx4Dkklu5lJe 6Mdg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712941212; x=1713546012; 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=WxKP5u29a6/h0HsN0BZtFE+WjVC08hp9oQij2YY8EAw=; b=ggBSRgUzokZHo38aD9AG2vV7CEAb6jkESwqX3bxvyzhapsSArmyahhkHaLxmn82E5P SSjzVdVDITa+q2y76Vgv/3UpXrr4kZ6hxeTvENUuz0VM4SJPillfxKNeX//CMssWGk88 Cc39qVt2+Ke4Ay4+++/hrHR/bu6LqnGO/fb5PlS6QGdAtFhK6cFXLmF/VnNbMd0Ig6tB H3/QG9OXm7w0nUtqdRe4PtmSyl1CtwmJ8T1KH92Z7k0eM+aZGNcdXba2wrBqHKB97F+h bCtf2p8WUdG2B4znpVkJWiV9kFnNYmz/wjlY4kgXpvr3uLvKrgBvR406VJcE5s/wV/rh jx8g== X-Gm-Message-State: AOJu0YzHESyRwmR+Ap2qeITLiQGpiz3nEW+N6rtLDhVoZR520CKFTZ4u 5NhXySrDzZ5pUK0yWTj2LEY9ryahVa+XYgoO8CKjOER1sQIf8tCX X-Google-Smtp-Source: AGHT+IEDlax+TT8XEPd4TyNvtscFCIC+ZewES7I7+7zhVrkQkdNUFL86FY/qVT1R887a4OpcdDgnpA== X-Received: by 2002:ac2:4837:0:b0:516:d2b9:20c3 with SMTP id 23-20020ac24837000000b00516d2b920c3mr2114909lft.10.1712941211960; Fri, 12 Apr 2024 10:00:11 -0700 (PDT) Received: from [1.0.0.7] ([91.185.79.145]) by smtp.gmail.com with ESMTPSA id o9-20020ac24349000000b00515ac0e4823sm555193lfl.149.2024.04.12.10.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 12 Apr 2024 10:00:02 -0700 (PDT) Message-ID: Date: Fri, 12 Apr 2024 20:00:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands Content-Language: en-US To: Dmitry Koval , Robert Haas , Alexander Korotkov Cc: PostgreSQL Hackers References: <28ed1ee0-749d-9838-955e-abff42fc44be@gmail.com> <86bfd241-a58c-479a-9a72-2c67a02becf8@postgrespro.ru> <0f655bcd-6487-4179-f9cf-c248efbad510@gmail.com> From: Alexander Lakhin 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 Hi Dmitry, 12.04.2024 16:04, Dmitry Koval wrote: > Hi! > > Attached is a patch with corrections based on comments in previous letters (I think these corrections are not final). > I'll be very grateful for feedbacks and bug reports. > > 11.04.2024 20:00, Alexander Lakhin wrote: > > may be an attempt to merge into implicit > > pg_temp should fail just like CREATE TABLE ... PARTITION OF ... does? > > Corrected. Result is: Thank you! Still now we're able to create a partition in the pg_temp schema explicitly. Please try: ALTER TABLE t MERGE PARTITIONS (tp_0_1, tp_1_2) INTO pg_temp.tp_0_2; in the scenario [1] and you'll get the same empty table. [1] https://www.postgresql.org/message-id/fdaa003e-919c-cbc9-4f0c-e4546e96bd65%40gmail.com Best regards, Alexander