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 1vC48k-008Z13-8b for pgsql-docs@arkaria.postgresql.org; Thu, 23 Oct 2025 22:50:37 +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 1vC48i-00CNSQ-9q for pgsql-docs@arkaria.postgresql.org; Thu, 23 Oct 2025 22:50:35 +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 1vC48i-00CNSI-2T for pgsql-docs@lists.postgresql.org; Thu, 23 Oct 2025 22:50:35 +0000 Received: from mail-lf1-x135.google.com ([2a00:1450:4864:20::135]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vC48f-003Qix-1C for pgsql-docs@lists.postgresql.org; Thu, 23 Oct 2025 22:50:34 +0000 Received: by mail-lf1-x135.google.com with SMTP id 2adb3069b0e04-592f7733dd6so1450915e87.3 for ; Thu, 23 Oct 2025 15:50:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761259831; x=1761864631; 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=6inKNDc65I0M3Y35XmP6ux2bGO6yUIokuyaCt38ruBs=; b=dftqOFbU5wlynAPxgIkZRLALWbpWPMJwe1juYb9Cvimjvt3epqwF/lV9utJUzgCSQY NrdqrKbheAERwm1GO7ILH8KBReBGvwGcOkLW+TaU4NSk+X09Jl68kAFKx7xbq9dsfo4w hYaNgjFauDdDhX381G4rA3C5UyA4ZCp1EwjB18TVLFsHr4663T8vo57nZuIKKpURqGp4 cecfp2SvGrMqyMTS74rGyb8+GWrMjue8qiCW+X10IwIHkV5pwOJiw8bzv0YABWh/CXzJ hDu2agiaDtpCcUdx96VGzStSNDcj3kG0eFEQVbp6U0d1w2ip0IGoEpqTTrSUwTFU/6mP ZOBQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761259831; x=1761864631; 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=6inKNDc65I0M3Y35XmP6ux2bGO6yUIokuyaCt38ruBs=; b=rSCMleh/itI9MGz0svrqKFifKNLx8dpXABNLhXlgOrWJ7YRotlK96nqoqpxqoiLBW2 bXxE3mwgTceHD1X4daNkbrxzk4wgpqHc4Scvd5Px42WsM+eplJWuOmDfELAIwS8GbD6t I3D+erSyj/3ak6D9oCYC05vnFQqYMU/pfrYGLxVtZjSq6K3qyU/o0cMIK27jqhbbToAq N9V+cKVwW4kA5/8CU2XZIEjoiaLjOucxe+yh7hbLCStd/nqcM0uBGeeOR1s7wjL5TQby O9QphS/R57kqSRrnH+NcsamABqkqEkjYE9MsxRX9SjvG0VYs2RZnf0nPfvxz1db7RqOf hLAg== X-Forwarded-Encrypted: i=1; AJvYcCVYVfLzdo3R6ymvnmBrgWfE1sFASsuCYjZCvo4upAQelGCb4BfsusJfUHldgI0z+i5n3YANR2wSI9ZA@lists.postgresql.org X-Gm-Message-State: AOJu0YzPKpz7RcFNvPf4oRn4acN4Y5ZMQJtP5AmFqjvioo5snmVmWCCC KSXrRCK899d2hp3WDbMNUm6tK37DxDGp69U++uXMi8FVnAmA20n8yQt5hBNnrcMkOvXTBBGjgHe 7hHAjfhi5xzfTQKWXJJUyyPW0YUq8FjlztP4tcow= X-Gm-Gg: ASbGncvveRfJUbbqyt+ilJWuHNjB+VMo1bvxLTLacxVjyKUuw9wR+ywqdsCDrxHfdzM 26F8SpWqT3PDmzlouEh7DqZYz0FXAQhnXEi9G7Mtt0ROsQqZ1dfeVMkiHF8ddXW2/n8wpeYb722 wmkWUfpOz4LXqpGWhpVYnJ38Un5t2yHQAObfBBxQIm/fOKrGt3KkGsmKUlireJVGM+2p8Yepy5j ui7SoO4dJw7QFnlRBDHwvj3C8Qh8cTlLHXNfLsfABWS9rR72/oByQ1Wby5VBaXX1XOeohkn+7ev zK6zkp8FILwkn4UWw3YtlS6ddbfskPy05BXpek22QuGwfn/cVgHmT668yQKNYQ== X-Google-Smtp-Source: AGHT+IFA+AycRuxt900CSgVOg8b8v6pAygJQIMGD6KQfpKaAHSBpB6W5FoqaivIKyAsnbdR6YtPMGTjEQYRw2bC5BK0= X-Received: by 2002:a05:6512:3a88:b0:578:6ccf:d031 with SMTP id 2adb3069b0e04-591d8534106mr7854504e87.35.1761259831186; Thu, 23 Oct 2025 15:50:31 -0700 (PDT) MIME-Version: 1.0 References: <82eb512b-8ed2-46be-b311-54ffd26978c4@ewie.name> <0a9d7393-1cf2-4d38-a648-631c1f93e345@ewie.name> In-Reply-To: <0a9d7393-1cf2-4d38-a648-631c1f93e345@ewie.name> From: David Rowley Date: Fri, 24 Oct 2025 11:50:19 +1300 X-Gm-Features: AWmQ_bm8PnGTiysmnjP2UL2fbAKKHU8-zEfrUZqzs-LiGInnMYd3ul2H6W0aLuk Message-ID: Subject: Re: Use uppercase keywords in foreign key tutorial To: Erik Wienhold Cc: 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 Fri, 24 Oct 2025 at 09:39, Erik Wienhold wrote: > This of course produces a lot of noise, but I managed to find and fix a > couple more places with the attached v2 (including the ones you've > listed) that I've missed previously. I've searched for "primary key" > across the docs previously but did not spot the matches between the > false-positive ones from the running text. I've not reviewed in detail, but on a first-pass read, I think this is worth doing. I personally find queries with upper-case keywords and lowercase identifiers much easier on the eyes. I'm not so sure about the "Should be pushed to all stable branches" part as it seems more of a general improvement than fixing a mistake. I imagine there will be varying opinions on that, however. David