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 1uCgG2-000p0U-K6 for pgsql-bugs@arkaria.postgresql.org; Wed, 07 May 2025 15:00:27 +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 1uCgG1-00EivI-KA for pgsql-bugs@arkaria.postgresql.org; Wed, 07 May 2025 15:00:25 +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 1uCgG1-00EivA-A4 for pgsql-bugs@lists.postgresql.org; Wed, 07 May 2025 15:00:25 +0000 Received: from fhigh-a4-smtp.messagingengine.com ([103.168.172.155]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uCgFy-000bkR-0j for pgsql-bugs@lists.postgresql.org; Wed, 07 May 2025 15:00:24 +0000 Received: from phl-compute-05.internal (phl-compute-05.phl.internal [10.202.2.45]) by mailfhigh.phl.internal (Postfix) with ESMTP id 750D41140182; Wed, 7 May 2025 11:00:21 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Wed, 07 May 2025 11:00:21 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm1; t=1746630021; x= 1746716421; bh=dkdmbCFnk/xNbqEYFMMsfHWvEl/gIoJtK59gURy5zwY=; b=L RMWqysQ7yRYKhLDbY4tK3pEauLEqZj2YU1yeOLyObjw4W0FXO6ICWJnRbHgbLycz 9VVVh+BYXBQcZ28HP5uI0VuGGnAHpDpvCZFZcG6/RVD4cuWuSEcBQx6izWojTI6C ImzDexu0pimIaAV8YoRWRSgVniLTUGPywPct2vNpoJhgq2VCC99n2J1MY+i1IWkm O2Ux8AgGgW+LmjbLj5Qw4Pmq/gnU5Y46a4L6nGipPx+L2iRy7XCSNzgUcCEYVamB ryMpcLssfQImSUJ6Im6dLAVc1IIy7Sw9Iy64yp4Bz7NKrbSCuBtURMN+5wgnExI0 p6gJya3SFW/L/dglCyY8w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1746630021; x=1746716421; bh=d kdmbCFnk/xNbqEYFMMsfHWvEl/gIoJtK59gURy5zwY=; b=o1R+rp5q/jV89EVyn 3CzJJ50AX+dCvPngDpIn5cbGYbfKbikD5Ci+ZOKVzdB2w/YtXioeA5moJ9p/q8hG kxtGXzNTiiwCdeyWhi3VxwTn3fX5Z+3DcyUmZXrq6PR2Nf2jO1kMcLqURrxub+TM oPqT5QhbIYvMQ5NTqdTA/fBdhTKBflfCywsFHUb6A+p1B0ZSG/ffz71ayr4BMKx+ YtKJTrYZqDoqSjGEje2yGeUoZCRm3rBLktpcvIvJ2BD0xk7wTHLMefVJ4IkkTupZ 4gw9Wd9JBgWIekM78f+SDQJ8K/mNeulWfDWmExH07Sr+cMU8v6D0hejgciDtOY4Z XZ1/g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvkeejudeiucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepfffhvfevuffkgggtugfgjgesthekredttddt jeenucfhrhhomheplmhlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsehkuh hrihhlvghmuhdruggvqeenucggtffrrghtthgvrhhnpeevheduvdevgfeguedttdekgeel kedtheefleelfffhhfdutefgieeguedvudfhueenucffohhmrghinhepvghnthgvrhhprh hishgvuggsrdgtohhmpdhtfihithhtvghrrdgtohhmnecuvehluhhsthgvrhfuihiivgep tdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsehkuhhrihhlvghmuh druggvpdhnsggprhgtphhtthhopeefpdhmohguvgepshhmthhpohhuthdprhgtphhtthho pegsmhduiegthhdvgehfsehgmhgrihhlrdgtohhmpdhrtghpthhtohepuggrvhhiugdrgh drjhhohhhnshhtohhnsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqsghu ghhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 7 May 2025 11:00:20 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1746629973; bh=KGV3yOjNbJRjpg+wdAkxPNnwd80x5QLvQMFq4Yc0Qk4=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=Pl4CkuGlEO9KtHtZOEMf8Iap9h5eslh0f0wezZg72L70Q+PsMGRvuMf8wMYvIaOat Uc2tfwdeTb9zaVZLZmjmWBWtf0Va4B9n/TpkcAr+ebT0EH1LjfuhKTpMLCvIuNdT8G lWDBD40B2wriBQqNL6iJ/cg9BVe76dcFE2SUtJSoATbUvZvkThiaDxDVtsGoPvuPaC D/MrzQPT4V9iwnVfsvOLZqdRMlRRJMRDbL7w8aR7lsGPwiCvx7jr0YgYXXGe4qXd9N y1DIG8XL5j015CxGv/FmND9T/aKfUcnAXhhs6WkMT/QpRQ/FQhy5OjK19yF4V4g6YE jvCFvbJJLOb7w== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 233D090; Wed, 7 May 2025 16:59:33 +0200 (CEST) Date: Wed, 7 May 2025 16:59:33 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: "M. BROUSSE" Cc: "David G. Johnston" , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18911: Bug in the command INHERITS. Message-ID: <202505071459.cwnqhmwv2ubj@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-May-07, M. BROUSSE wrote: > I'm a little confused because I already used inheritance on PostgreSQL 16 > and attributes were given to children tables. So, is it normal that > attributes aren't given to children, if you said so. Please explain what you mean by "attributes". Most people here consider "attribute" to be a synonym for "column", but I noticed that you used both the terms in your first email as if you meant two different things. It helps if you show the exact commands you run (to create the parent/child tables in an empty database), the output you get, and explain how that output differs from the output you expect. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "You don't solve a bad join with SELECT DISTINCT" #CupsOfFail https://twitter.com/connor_mc_d/status/1431240081726115845