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 1vGqKK-005WND-2w for pgsql-docs@arkaria.postgresql.org; Thu, 06 Nov 2025 03:06:19 +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 1vGqKI-0059T0-W7 for pgsql-docs@arkaria.postgresql.org; Thu, 06 Nov 2025 03:06:18 +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 1vGqKI-0059Sr-OJ for pgsql-docs@lists.postgresql.org; Thu, 06 Nov 2025 03:06:17 +0000 Received: from mail-lj1-x234.google.com ([2a00:1450:4864:20::234]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vGqKG-005eMT-04 for pgsql-docs@lists.postgresql.org; Thu, 06 Nov 2025 03:06:16 +0000 Received: by mail-lj1-x234.google.com with SMTP id 38308e7fff4ca-37a48fc491aso4125851fa.1 for ; Wed, 05 Nov 2025 19:06:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762398373; x=1763003173; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=VK8rifrYfNIEbwTomhpQqYhiWYH84W117ifuVSGm24E=; b=ZOdEVoR/ycVXsSfKBsD+5Zxs1MR94PPmMWyBAVLaw+Tm41W77uOPgfTXWuVfdwej67 Cz2VcQVZyC/uV7BgyUkHqtmgL6CffzywJhtOzsz+QhccCdWMFG0o8DOYzIvVBAsR+/nH ZvbcbEPwyocKjiwPbTt1Dv77o2KRzDolOFRlcsYMkbzTUzU4Jz/Wk4CH/caNxAyTXzx9 N40QLnER1G0ojgLNUvmryPWG7BnaOCqq02UtZMzk8tBp/PiuZK82PKBr1jdnSn5bvLhh 0rdbATP2xPn7oLopITxD+Qt7BDt34h4WpQnjepWkumJDgFFMEjis6DhGxhqXbLO1+wsJ 9j1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762398373; x=1763003173; h=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=VK8rifrYfNIEbwTomhpQqYhiWYH84W117ifuVSGm24E=; b=wcZPD4r2rEHWC8jqbAdtqgD61rG2n1dt4pxCRPM5Q+7eIxe/mBKoIvgkU3m9a6zksm fUvD+KjwpZowC7Q7gYEanZbwT8ayeMcbEGCp8d/tdzU/T7xjs3nk04ogdNjS3FUyYOGa vozH5CaFmkzS4Ie+8zi3sjueyWwe9N1ZnBiAYmaX45fH7nYOhC6KZDCjmPZlmGUgTsg4 3y/xHoXXqp8ZPzNdxomQXoFb7QV3YOVwAaYow4ElxNFx+zt5CL6a2b9DXS5d/bv1cLGt t3mv278Ts8fmZ5GmqhRlm2v5VHpPEI5UN0s4tqA4g+VQRZ7R1tqwvfn+cTZXK7qnd4BK G3zQ== X-Forwarded-Encrypted: i=1; AJvYcCVa3xXDSEx2m38+zjAP1p3ggmV3tBL6mVyFhCXG9RKVkytoSjrobvOFCZPT1kd07VBVFQX/842UF9GZ@lists.postgresql.org X-Gm-Message-State: AOJu0YyoG1kH68aqajOiZuAs9sQ2OuGg21myXS/s0Rru7m2UZC1n/CrP 7shjy91XQFM/nm1zfHeePsc5wQLNdnOUd6nWNhqYlgqyuFcS4bf3WWr6h9O4328RF9KtOdj6/QD lGwzDtF71P4lWJplgjSUomFwQ1qkfysE= X-Gm-Gg: ASbGncuu8+xeT/MmWsE5A0qr6+mB7wtVXsCo8M/1m929xbGPwHjs/we0lHt6pmFEGh7 BL6OZJaHzA/cVllkeb60tI/xU7kkICpI6zfJ9OAM5MiVdGd4fDwjXw8a/CKMKobAkUqrui3SGkd Mbp57CxyeW0z5xM8+QQqNGjtLghJAMpMMnZ6HW8pkQzW5XYwBBh7KZFQKP2jQ39vVkq/vxdB3Ur O3c59JL6V6dR7nbQX2XzqGBBt8PbZEcxXcDg5SGJsosMz7ObqdaPSOGX0KjVxNzk6TOPZNan+RH EE0dKMKOO87kq2w6BRT9gTCj+dyoaVYmwHxpvyI/7lnZbqLjxiI= X-Google-Smtp-Source: AGHT+IGlgqsZaknumYBwmpl0xIyEYXhrlbgfVvR9RJekwpJoPDFkOir1H/Ohd/1a6F2q3HbABM8tmoyxkCFDxc3hCSQ= X-Received: by 2002:a05:6512:3195:b0:594:33b4:9962 with SMTP id 2adb3069b0e04-5943d7c258fmr1574007e87.27.1762398372803; Wed, 05 Nov 2025 19:06:12 -0800 (PST) MIME-Version: 1.0 References: <2903384.1761770924@sss.pgh.pa.us> <0a68a965-4599-4af1-a1eb-bd8e1be75788@ewie.name> <32882add-b671-42db-a041-e2c2c5b7c315@ewie.name> <4487a138-c4d2-4b06-80b3-5afe7f8e5d82@ewie.name> <971a5a3d-c200-4700-824b-f71a6e831994@ewie.name> In-Reply-To: <971a5a3d-c200-4700-824b-f71a6e831994@ewie.name> From: David Rowley Date: Thu, 6 Nov 2025 16:06:01 +1300 X-Gm-Features: AWmQ_bmNoGt18R1rU4lfRoqXOd3gQGvldXa6i9KziAsLmQUo6f16AGkeRZVttJI Message-ID: Subject: Re: Use uppercase keywords in foreign key tutorial To: Erik Wienhold Cc: Tom Lane , Bruce Momjian , Nathan Bossart , Euler Taveira , pgsql-docs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 6 Nov 2025 at 07:09, Erik Wienhold wrote: > > On 2025-11-04 03:09 +0100, David Rowley wrote: > > I think just the keyword upper casing is a good idea for now. I'm > > starting to lose hope that there's enough merit and consistency to the > > proposed whitespace changes. Maybe there's a subset of it that does > > make sense to do. > > Done in the attached v6. But I kept the few whitespace changes on lines > where I change keywords to uppercase. It's mostly a single space after > commas in column and parameter lists which I think also enhances > readability. I reviewed this and double checked you left "uPDaTE" in [1]. Found no issues, so pushed. Thank you. David [1] https://www.postgresql.org/docs/current/sql-syntax-lexical.html