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 1vG3Bl-0070Qw-LA for pgsql-docs@arkaria.postgresql.org; Mon, 03 Nov 2025 22:38:12 +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 1vG3Bi-009ti9-Dz for pgsql-docs@arkaria.postgresql.org; Mon, 03 Nov 2025 22:38:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vG3Bi-009thz-3i for pgsql-docs@lists.postgresql.org; Mon, 03 Nov 2025 22:38:09 +0000 Received: from mail-lf1-x135.google.com ([2a00:1450:4864:20::135]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vG3Bf-005pCB-0F for pgsql-docs@lists.postgresql.org; Mon, 03 Nov 2025 22:38:08 +0000 Received: by mail-lf1-x135.google.com with SMTP id 2adb3069b0e04-5942ee7bc9dso1256774e87.2 for ; Mon, 03 Nov 2025 14:38:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762209481; x=1762814281; 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=cHBQFDofX9vJeUo/HE2B1VYWk9hGkQJYYIeZOIIIOak=; b=WearBPbUlp8/Fb82/MOi31BGyoA1eWhNzU5X5+Liy7xS/k70KwsumIeRNO01csVSjm ntB+qoks2wfG5kwtsy1XM7pLEl/UjmViHlxxc+K5LElcG7uUoayqhc8ajndWTHqIVYxW zLCGt3XewiNEZ+ZAJp2XB3iJEkHxyqumMQdGL/hs96fJ5PpANHXJguQkcLutOpsCAkwV 9wfH/jtMhNBOnacm5MmGc/FCP8UP5XzQdOXF8ou5hrvpiSxjY8IEETTZp+/lH9l7cwq5 faUFDzfrGxkR/B2gYXW5dJq96RRucZKXdshCQfS+S5KWkD4o/FhUm9N1N6PNTJepBsW9 IPTA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762209481; x=1762814281; 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=cHBQFDofX9vJeUo/HE2B1VYWk9hGkQJYYIeZOIIIOak=; b=l/j3zhu6dHDcTh1o2vBVezcOHa/+hCUVpkx+D5gEQYXA8AnAhft/c5oYsTEHPI8Ig8 VfguT/Tw9sUlT7ybYZNskKraFYEALH6qCH4sEPd4J18eX5H75ST8Ljfbva5mEcKPzTp3 lVPHwyr1T+t0OiYFsrwKkUKNndNwCSrR5mRP6Fknlp4iSpvVdgxJcGw2KC2OnywneNVa mg3V/55hh2CWiQ1nPVp9WJ3KaCk9CLDbo5XXiLs+kykLa5pdsIjf2ZChdWjv8RMGMt/+ yQpkbauzcBElqQ81NQHlzcOl8YvJqD+DlNgLO3r0KKY0V6IzbWTO/Pma1cXVLb8dj0J3 fiew== X-Forwarded-Encrypted: i=1; AJvYcCUdK/5VxVggVtQJssnu4igba0YvW6HkloKTGma5vkDVE3Ls7aZGqUsOAYK6IaRipPU25zXCpbx3Fuau@lists.postgresql.org X-Gm-Message-State: AOJu0YxGczWbrYecUkbAwQP1Qo+svXNyyzpkDHHGiUQhAMY4e/19qJ8z hdk6zg1MEWl76TAyaI11cOF3Kkz/h1QnSrsecpX6eGnqYZOflXABTKiBj7GttQ7ugymRqjNclJO RQUDQaU7rdpcDx9/uKm2dZsCHVpIqWto= X-Gm-Gg: ASbGncuFja3K7dHT2P01OafzXqfJka3rp5BN7XfC1XQG1mfZizQ+7qC6ZItiT6afdA1 nHOuUMSSFJm5a96bIBjQbLuJnXrQs66Yo6yRW2xhE76t7UKBjQFidaHWIsAZpUROTDFfP9iEsOV uE6EQbjgdhc3qvyCcIGDySD2hWcWo6uGMoCpNYK0JvxZrN5rdTlWV+Pkly2zwz59RrM6Upn7u5Z Px2oHP6JIABF1Licyr4kpSSkJX55h7TRWaB41dV9pdOUsJHQwQrVMboHdxOT3SpZfJh/cUUnpJ7 vUQPiUpxr/0Jpw/NjeCVZh5wspVng2k4jH08HqtTrrpA818vmU0= X-Google-Smtp-Source: AGHT+IFXNQAsY4NoKUfPqoDMV+2ToiVEji/srvunr/3xUqnPOqfWjyOpNX9hBCqO19G+OLhl2/m3Y7Cr2hXdBwjAflE= X-Received: by 2002:a05:6512:1285:b0:591:c2f8:9a5a with SMTP id 2adb3069b0e04-5941d559c6fmr3675487e87.35.1762209480971; Mon, 03 Nov 2025 14:38:00 -0800 (PST) MIME-Version: 1.0 References: <0a9d7393-1cf2-4d38-a648-631c1f93e345@ewie.name> <2903384.1761770924@sss.pgh.pa.us> <0a68a965-4599-4af1-a1eb-bd8e1be75788@ewie.name> <32882add-b671-42db-a041-e2c2c5b7c315@ewie.name> In-Reply-To: <32882add-b671-42db-a041-e2c2c5b7c315@ewie.name> From: David Rowley Date: Tue, 4 Nov 2025 11:37:48 +1300 X-Gm-Features: AWmQ_bmF7-APtkBdt-It90eW2gJrASEuZcn-rn01eBFNH-sa8QmKDGopwYJZhQo 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 Tue, 4 Nov 2025 at 09:06, Erik Wienhold wrote: > Fixed in the attached v4. Except for one match in dblink.sgml that is > the sample output of dblink_build_sql_insert which actually omits the > space after the table name and VALUES keyword. I went through all these and I think it's mostly good. However... It seems strange to me that you've made so many changes to transform "CREATE TABLE foo(" into "CREATE TABLE foo (", but you've done the opposite for CREATE FUNCTION and CREATE PROCEDURE. Did you go with the majority rules here? It just seems a bit hard to follow what the standard is being enforced here and if that's hard to understand now, what hope is there of people following that in the future? I'm starting to wonder if adjusting the spacing here is a worthwhile change. David