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 1uMl0T-002r5Y-Bc for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Jun 2025 10:06:01 +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 1uMl0R-00AX4k-5u for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Jun 2025 10:05:59 +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 1uMl0Q-00AX4b-SO for pgsql-hackers@lists.postgresql.org; Wed, 04 Jun 2025 10:05:59 +0000 Received: from mail-qt1-x832.google.com ([2607:f8b0:4864:20::832]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uMl0P-0009Au-1a for pgsql-hackers@lists.postgresql.org; Wed, 04 Jun 2025 10:05:58 +0000 Received: by mail-qt1-x832.google.com with SMTP id d75a77b69052e-4a44b0ed780so55334421cf.3 for ; Wed, 04 Jun 2025 03:05:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749031557; x=1749636357; 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=OIyGMPpXVquI/bmTmSlwg59LBxgwITLeo1RoX1fzj+Q=; b=d8mUGKfGBWfJhKbZ7aea466ABwwDU4X5BGqTTVvuLiKID9qqys0T1G+ONCX4xCZNrN SrmloWnEzpC84RFMqm56GUti7gwFMbwWEmK40iAprSx22Ricdlx2hlSKJTRp4g+y13hb WOLtwinZc2AOrTOZ2+Ip+pavRW6vGDGnE0j/SqPgpIZFgNmJw5CjtceFt+QrNyf5iA2C AYe+hRp6UPEzp0GppKiu5KtWXKVV4GnLfUHnqBI7yW10sEcmwRTMTPbL4sI5twEyz0OR w1DTS+WqtTd4rnubqtQlmdMkOPwcsqM18f5r0Q0wMiAPfjxeJYoKN0ZI8xxYWQNObn6i ed4w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749031557; x=1749636357; 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=OIyGMPpXVquI/bmTmSlwg59LBxgwITLeo1RoX1fzj+Q=; b=KHqA7wAdXIoYxTe9WRA7Fx4z6BdC+JqtuNDPmxliWXyDz2lldk+Kmq5n5o2q/9GX8U O/XV95oFQfShL5xmvGwpwYeknXooZWS5tQ0p7qsW5pAtp2T/9aXiopMt6Cc0mglKu6MV rDcTr6RXB+e43u65B8cbuY8Y8gye4yuh61Lg7ejTFAxZD3vTvqEK9/tZ6uD5RTN/xFHl yI+KwEJcYEJA+xN2DEsyJOR/ghaAydlJu7GYXK1OF56tVE0QQScL9V7xw4xoe+amNYhu s8FfgRpdhVNC+/VB6zL/hdCPJeZBpzmJbwLJ7OOoIS/hhg8z8/0R/HUw1CWh0KXM2QMM 1jow== X-Forwarded-Encrypted: i=1; AJvYcCWBXA6HNHhd72ZKDL9RNSc8+2WWk6TyC19Hj0W5kJ7V5KPLieb/r92def6IQSB8bnR8+n2xB4muLo7fkPSu@lists.postgresql.org X-Gm-Message-State: AOJu0YzQixEqJj0cSThrkeqQYQK3smMcopp/Kbq/zjD9m6NxlbV42L8W qek83hA0rbk97jKw/c1r0jQ+bAwOL6yjq5hrkdKkfYMUL7yazrmPNihybZiN/CP9f73dCrBl+6L o3a1uM0/cl6LK7AAgxMnyNBv6driRtQ== X-Gm-Gg: ASbGnctBL+mEo5IVHfOXzlXady9L0XZ400V6phjCBAzJrMrz11TUPwek1zSjR9lLbEP lS5BmsMCxLf3Mv0bTCr2gaLE5QU5csu+eiPnSXAnGgm0fGgxOrOw5CtNj1QF1zYwCHf+cr83pCe 71o6/v5r1Zs327gPSKovVmMTLvZHKq3kAX X-Google-Smtp-Source: AGHT+IEApT5R8e9hwAg/DukKIp/G/tMly1yBbqbCjUotYVytBpj2eJaY767eALSJdxSwEC5ZVKTjrNayxgLbN80llvo= X-Received: by 2002:a05:622a:590e:b0:4a5:98ad:5640 with SMTP id d75a77b69052e-4a5a578425fmr37419531cf.23.1749031556519; Wed, 04 Jun 2025 03:05:56 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Shinya Kato Date: Wed, 4 Jun 2025 19:05:20 +0900 X-Gm-Features: AX0GCFsYySVv8jOeqT3q4U9aB2wrGDCil7VRe0E_Kk6O520C5m1zkDQTRRBai3E Message-ID: Subject: Re: Partitioned tables and [un]loggedness To: Michael Paquier Cc: Nathan Bossart , "David G. Johnston" , Postgres hackers 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 Wed, Jun 4, 2025 at 6:55=E2=80=AFPM Shinya Kato wrote: > > On Wed, Jun 4, 2025 at 6:42=E2=80=AFPM Michael Paquier wrote: > > > > On Thu, Sep 19, 2024 at 01:08:33PM +0900, Michael Paquier wrote: > > > I have applied 0001 for now to add ATT_PARTITIONED_TABLE. Attached i= s > > > the remaining piece. > > > > And the second piece is now applied as of e2bab2d79204. > > -- > > Michael > > Hi, > > Should we consider preventing tab completion for PARTITION BY > immediately after CREATE TABLE name (...)? Or is it fine to leave it > as is, given that it's syntactically correct? Sorry. CREATE TABLE name (...) -> CREATE UNLOGGED TABLE name (...) --=20 Best regards, Shinya Kato NTT OSS Center