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 1s0KGK-00363O-Jd for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Apr 2024 12:01:08 +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 1s0KFK-009ntC-0k for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Apr 2024 12:00:06 +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 1s0KFJ-009nt4-NI for pgsql-hackers@lists.postgresql.org; Fri, 26 Apr 2024 12:00:06 +0000 Received: from mail-lj1-x235.google.com ([2a00:1450:4864:20::235]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s0KFI-0008Ry-BA for pgsql-hackers@lists.postgresql.org; Fri, 26 Apr 2024 12:00:05 +0000 Received: by mail-lj1-x235.google.com with SMTP id 38308e7fff4ca-2df83058d48so1804921fa.1 for ; Fri, 26 Apr 2024 05:00:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1714132803; x=1714737603; 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=E0l2P+KqjRXdeIVPe984ryXlFX6s+KGuHzgf9nDLgAc=; b=QmKTEcrNiWOx8G66K8v5W8Xo3knwzscLHuLDe2A1hyUVDhS6CBg+SY6stTozxJw2bv yyGKknpAMWC4owr6a8hBprDkseyQoZLti45pFwLp0+HNkxZEPrF2bG/K0iOev0JiUWrg umDzSRGEub5W/aUfJr3HJp+HR44kotGwDX+t84epbs6Iq0/upKMTe9tHlmycHM66vd+7 oQZJeUFG96Cfx/mGWNqbEqHr54rGOzHXSMOvzsVRkOD5Nt3SfH5x2zlLUe7yPAdiEtma cxs0j0XtIfm8Th7vh/pOY+Zt3lWqKdQ7LpPSDqC4TxmnYwYx0sDcOfDS/nenWsi4Dh1V 9OdQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1714132803; x=1714737603; 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=E0l2P+KqjRXdeIVPe984ryXlFX6s+KGuHzgf9nDLgAc=; b=HstP+sUwPh0tIm+zWIVXfS6nGtNupQrss4HpbDT9I96P3bsQNAX7r7u2/44REXDaap /bya+GzRNtOxCcVViZo1g1Ww0bK102M1V6XfzJUBiabe9/c9syYld6TxVFzjZlE3GWwc VTqJySkVsqmrlB3XPCmUfu33mZZz66oi5hJBvs4fnpO62pXTjOC0U4WN2Bs2NavnWsWw 59T6i8U4DSMnEBHRT4mkh3RphwGnhb5PyjfgSlb5uf4M8+QkeEFR13npS7wRu4WPSs8Q Buj6tE/M9Zp6odWurTnRpN4L3qfG/cgt6R2Bd61JdCAZm1eFTowNrfKSGbfpY4MGhin7 cDvw== X-Gm-Message-State: AOJu0YyluPwmWQmY81XcLlbnYspppl7EUgXctRonvb1U/oi7d4FEOoxk JxaJFja/j6zj3CY9hjnpEbO/Df7IRgxNWqWqdLCLXvLJdfhunJIY X-Google-Smtp-Source: AGHT+IH2A0YtQIL0S5N8Q96IHdK/aoWPWaJnGRpu2UVQ9aH0YhmURnscrnNkL6yVeKYRjD80JWPUZA== X-Received: by 2002:a05:651c:2226:b0:2d8:901f:7f4d with SMTP id y38-20020a05651c222600b002d8901f7f4dmr1544898ljq.29.1714132802366; Fri, 26 Apr 2024 05:00:02 -0700 (PDT) Received: from [1.0.0.7] ([91.185.79.74]) by smtp.gmail.com with ESMTPSA id p19-20020a2ea413000000b002da5b137aabsm2632911ljn.29.2024.04.26.05.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 26 Apr 2024 05:00:01 -0700 (PDT) Message-ID: <3b8a9dc1-bbc7-0ef5-6863-c432afac7d59@gmail.com> Date: Fri, 26 Apr 2024 15: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: partitioning and identity column Content-Language: en-US To: Peter Eisentraut , Ashutosh Bapat Cc: PostgreSQL Hackers References: <8801cade-20d2-4c9c-a583-b3754beb9be3@eisentraut.org> <3382bb91-c039-4020-8889-577b9536e12a@eisentraut.org> From: Alexander Lakhin In-Reply-To: <3382bb91-c039-4020-8889-577b9536e12a@eisentraut.org> 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 Hello Ashutosh and Peter, 16.01.2024 21:59, Peter Eisentraut wrote: > On 09.01.24 15:10, Ashutosh Bapat wrote: >> Here's complete patch-set. > > Looks good!  Committed. > Please take a look at a new error case introduced by 699586315: CREATE TABLE tbl1 (a int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY)   PARTITION BY LIST (a); CREATE TABLE tbl2 PARTITION OF tbl1 DEFAULT; CREATE TABLE tbl3 (LIKE tbl2 INCLUDING IDENTITY); ERROR:  no owned sequence found Best regards, Alexander