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.98.2) (envelope-from ) id 1xEYke-00000001A7R-48qX for pgsql-docs@arkaria.postgresql.org; Wed, 07 Oct 2026 21:00:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xEYkc-00000008a5d-3Nau for pgsql-docs@arkaria.postgresql.org; Wed, 07 Oct 2026 21:00:34 +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.98.2) (envelope-from ) id 1xEYkc-00000008a5U-2HD5 for pgsql-docs@lists.postgresql.org; Wed, 07 Oct 2026 21:00:34 +0000 Received: from mail-wm1-x32c.google.com ([2a00:1450:4864:20::32c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xEYka-00000000sbg-3J3i for pgsql-docs@lists.postgresql.org; Wed, 07 Oct 2026 21:00:33 +0000 Received: by mail-wm1-x32c.google.com with SMTP id 5b1f17b1804b1-4a1698ea378so19597815e9.2 for ; Wed, 07 Oct 2026 14:00:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1791406831; x=1792011631; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:cc:to:from:subject:message-id:from:to :cc:subject:date:message-id:reply-to:content-type; bh=ReojGdxdhVEnmsFcj78gTTXqGB+FCKPEFfJVoDUo4Oc=; b=Hl9UFk/iouY9d1iezGJYLSQul0rFff7pveZZw/InenNsT4uEn2ikfETfQv5GZUOjDt 0/OEayhB7Rmk3eFFXDrtErFsTGm6piJ9jDLjf5PjJbAHzxY4k1JRCbvnxhCLW0JOClLD 5nau/rEWxFxZwm4endcwvPXipR0LNbDKVTrPS0LCmPAwBViSzhbPIdPwsch4lHwLhGUP 6yNEQ6iE9rCp47FWAwkxDNRQ7cOozsKWDnwylBcXU95mMgeGxLJ2LVAyo04aAFClRwdh smb+zPGgMu5UzzuZxc4JX3CB3ZhNynvC9x9I1xdP2e33GKof01m4N1VvjNI1jJm3L7EI Feog== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1791406831; x=1792011631; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=ReojGdxdhVEnmsFcj78gTTXqGB+FCKPEFfJVoDUo4Oc=; b=sfX5QWqZZz9NmOy4+VmMflmQg3R9qOfrFuBmk2KggebGrBaEqPiPJIGN89bVVduX7y BXTa4tfXRh7mWaLqExiiZLWUBJxi1QT3x5+rJlesPvm+J+ITWKtROoFb2vRy9jjFFC/1 emJoM9l8rsi7E+Vomkb1Uej8fukW/nXIdxgF4jBIhaXrdZbM/81cJ0trqeBk7zAvkEG/ 1r7NSt5S/ITmnfnhIW0n05Xq4dNdrwmKdeBdboww1MMx+OvWiztOtwUbinYBIVX9KPud Mh0vY1NuDFcbMpQxv/xVIn8+i35r/AuJh31dlEruK88Rey48ftqNAp3PbcV0GGdWoX9A Z4NQ== X-Gm-Message-State: AFuF++nfi8PcskT8ngPgyH1UhizmX5RIi6sXx4L72NjywgStPxX1WaPZ kOXVhX8mB0d9w9DBxkvQ1+h41VRkE8NhKumBejNPw/6x/NTjs8RPiQtpToyH5jpMf2U= X-Gm-Gg: AYBFou3FPH8qSF5JHo0C42Ov+iw8h4/0CZIBcN40owfngf8JLUo0RkYrkDxdMvP7Xyc vhRFatIAunzuMsideSZWQMXDgyVRAlXTFNXaHrbFo1p2SDsCmg8SaElA8sZLy2nDbMNQhX+sg/5 3ZpmS718ZQHCOWTlzuPJdtHg7e8cBQk05c7YGW5gje2Xgy+wUdg6PzGMtRIVEz86HH2bggK7DvY kOW0xyT+RLCc9p5oje0i4tco5WzURjfYrRl6HE2+du2WusIrDO3xle3eUoXStYmyHzSmXhByIx2 zl2wGXXIjKBjw957QCm4XyXPwL/HMO6DwX2xXnrKRk88U7H4LE1zp++71JE8udfTA1eHktw53K8 zYIxkjXHi1O/O+8ao4LJ10L8iRT0LnqINvARkYzVJY1YbDo+B0d/AhMkUz/bIv/agC7O4vWj0Ey xWV3mleXsnFa0HJ24Sw1L7Nqr+l+49Z3iYKphLthW2/ZvRSB00edY3ZjyviyQRwc3waZlYuiZkb Ty/YyOnPFrp09tnV/SAu6bJfNdyCc7H5H3i2ySCzA== X-Received: by 2002:a05:600c:4ecf:b0:4a1:7d08:780e with SMTP id 5b1f17b1804b1-4a1800ca15fmr59127455e9.1.1791406831337; Wed, 07 Oct 2026 14:00:31 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:b677:677f:591c:a18a:2956]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4a17fc4a588sm76405465e9.1.2026.10.07.14.00.30 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 07 Oct 2026 14:00:30 -0700 (PDT) Message-ID: <9a545ec303e4c1a124c6b41b1b426b7c74cdb1c2.camel@cybertec.at> Subject: Re: Improve "3.6. Inheritance" tutorial From: Laurenz Albe To: =?ISO-8859-1?Q?Matem=E1tica?= A3K Cc: pgsql-docs@lists.postgresql.org Date: Wed, 07 Oct 2026 23:00:29 +0200 In-Reply-To: References: <179088091522.1026193.3570337969572056877@wrigleys.postgresql.org> <3c6bdd69af16e90e3da20be277e836b25eeee1a5.camel@cybertec.at> <344e5b7d87a8c0e8e8f5f4924345b1caec1a4418.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.60.2 (3.60.2-2.fc44) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2026-10-07 at 16:28 -0300, Matem=C3=A1tica A3K wrote: > On Wed, Oct 7, 2026 at 11:43=E2=80=AFAM Laurenz Albe wrote: > > On Fri, 2026-10-02 at 12:23 -0300, Matem=C3=A1tica A3K wrote: > > > >=20 > > > The main technical concern is that querying is not explained on it, i= t's > > > explained on the "details page". > > >=20 > > > More in concrete, if you add "In PostgreSQL, a table can inherit from= zero > > > or more other tables, and a=C2=A0query can reference either all rows = of a table > > > or all rows of a table plus=C2=A0all of its descendant tables. The la= tter behavior > > > is the default." should be a "complete" explanation of the feature. > >=20 > > I think the explanation in the tutorial is quite clear: > >=20 > > =C2=A0 Here the ONLY before cities indicates that the query should be r= un over > > =C2=A0 only the cities table, and not tables below cities in the inheri= tance > > =C2=A0 hierarchy. Many of the commands that we have already discussed = =E2=80=94 SELECT, > > =C2=A0 UPDATE, and DELETE =E2=80=94 support this ONLY notation. >=20 > Here, "quite clear" is the discrepancy. >=20 > [...] > > My impression is that this happens *after* you read the full version, add= ing that > sentence to the summary would make it more clear for some users. I personally am not convinced, but perhaps others agree with you. Do you want to prepare a patch? I think it would be best if we can avoid repeating the same information in several places. Such redundancy inflates the documentation and makes it harder to find all places that have to be fixed when something changes. Perhaps you can move things around to avoid that. Yours, Laurenz Albe