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 1ruxmW-008nmo-1B for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Apr 2024 17:00:12 +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 1ruxmU-0031F0-8K for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Apr 2024 17:00:10 +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 1ruxmT-0031EP-V0 for pgsql-hackers@lists.postgresql.org; Thu, 11 Apr 2024 17:00:09 +0000 Received: from mail-lj1-x22f.google.com ([2a00:1450:4864:20::22f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ruxmN-000P8l-If for pgsql-hackers@lists.postgresql.org; Thu, 11 Apr 2024 17:00:07 +0000 Received: by mail-lj1-x22f.google.com with SMTP id 38308e7fff4ca-2d886f17740so11716271fa.1 for ; Thu, 11 Apr 2024 10:00:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1712854802; x=1713459602; 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=bwakNNvNnIkgGkv2sG23tN0mt92ObmaqyCc9+MXNTdE=; b=VC91tPg8enNB6AxYf48FsTW+aduYZHuTzml4G96Qa0kwnMMuaqCwUeAiCgWlP19xKF HBv3MjgTHrgCIk8uH4lz1cpKmE1r8TsztxFx0xDsEx7FGfqUa5BYr3iFVkc2yhr6I2GY DCpC0sk46eQb/nmm6JCLzwZ42FcYHzlVw2sbd9+d0pl026o9mrgpo+sHLdO5tX9bffdc 0VFnMUHSt7YE/xGQHKmndRzd9j44etq2BrAHGVrC+Y7yuBqyrnxqz55pXALbUIRzgRCw zZ6Ao9OpIPnnK3DZzUSOzppnBWIkwRScDZlRY3ZTEUsEZl1+s7URRfFwivBEY69F/eu3 UM/A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712854802; x=1713459602; 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=bwakNNvNnIkgGkv2sG23tN0mt92ObmaqyCc9+MXNTdE=; b=mH3J4eEPM1HaT9KtI9/gj/H3SUv3MEZaSIuCBWhO5Bo1dd5bQvWchZAoPu3s7tUJKH hWwQcePppXvVISRtPVbWN6cDp85QDVWmSAuDLhxIUiVwVc7upuz1dJUFDfDK0rifp+34 nhfmhAxe2AQEmcsg5sRtCjzUFavTuMgjve3KW3eLFVcxdI4LQVwQEPcvuqK0zDt19d0M CdzHq1GByIJyIOid/z46SNhev9mpeUFLVdolG32BkMKJ7eXtzM0Y+UTElh6wD+rSVEPt ZTeZ33DAZnKZ5Wy5wHJrdmHJoCUAWsuJ6xEme7y9nWJ1EKhLqKYS64eF+YREqiqmrJuF X9lw== X-Forwarded-Encrypted: i=1; AJvYcCXa7tf+wkkiopDJn5O4dSQfBquYOT4Nv6IE/CRKnAEpGsOVs6tVmnUGdCZy7hxZ29lFlTlGapi4tZ3mCIRkdcic3j81YUZgl4KES1mCg1B04JrJ X-Gm-Message-State: AOJu0Yy6InuhpGOikKA8TXvZJAqsGF3Bh7iDnNyuzA+CtKNWtuR4vVi/ R9ZJ9OPw++ujB8KcXJ8NBTnLTyAhrSt5hIGv1XNDszmHSvJyaEbo X-Google-Smtp-Source: AGHT+IFv77jjWvxidYXHvfwmms9BDh90MJnHIb6dxxlMXVPHyC7wOD8bmtVW8U/oWrh/4OXfgzQe7A== X-Received: by 2002:a05:651c:1543:b0:2d6:eecd:8b08 with SMTP id y3-20020a05651c154300b002d6eecd8b08mr1080682ljp.3.1712854802066; Thu, 11 Apr 2024 10:00:02 -0700 (PDT) Received: from [1.0.0.7] ([91.185.79.145]) by smtp.gmail.com with ESMTPSA id t16-20020a2e9d10000000b002d87e936833sm256403lji.125.2024.04.11.10.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 11 Apr 2024 10:00:01 -0700 (PDT) Message-ID: <0f655bcd-6487-4179-f9cf-c248efbad510@gmail.com> Date: Thu, 11 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: ru-RU, en-US To: Dmitry Koval Cc: Alexander Korotkov , PostgreSQL Hackers References: <3a4b9c1c-3edf-4e29-9629-b4113aefb0f3@postgrespro.ru> <28ed1ee0-749d-9838-955e-abff42fc44be@gmail.com> <86bfd241-a58c-479a-9a72-2c67a02becf8@postgrespro.ru> From: Alexander Lakhin In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 11.04.2024 16:27, Dmitry Koval wrote: > > Added correction (and test), see v3-0001-Fix-for-SPLIT-MERGE-partitions-of-temporary-table.patch. > Thank you for the correction, but may be an attempt to merge into implicit pg_temp should fail just like CREATE TABLE ... PARTITION OF ... does? Please look also at another anomaly with schemas: CREATE SCHEMA s1; CREATE TABLE t (i int) PARTITION BY RANGE (i); CREATE TABLE tp_0_2 PARTITION OF t   FOR VALUES FROM (0) TO (2); ALTER TABLE t SPLIT PARTITION tp_0_2 INTO   (PARTITION s1.tp0 FOR VALUES FROM (0) TO (1), PARTITION s1.tp1 FOR VALUES FROM (1) TO (2)); results in: \d+ s1.* Did not find any relation named "s1.*" \d+ tp*                                           Table "public.tp0" ...                                            Table "public.tp1" ... Best regards, Alexander