Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1EN1-0005yF-6r for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Dec 2022 22:18:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p1EMz-0002vs-Of for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Dec 2022 22:18:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1EMz-0002v7-Az for pgsql-hackers@lists.postgresql.org; Fri, 02 Dec 2022 22:18:57 +0000 Received: from mail-pl1-x62f.google.com ([2607:f8b0:4864:20::62f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p1EMw-00040c-CS for pgsql-hackers@postgresql.org; Fri, 02 Dec 2022 22:18:56 +0000 Received: by mail-pl1-x62f.google.com with SMTP id k7so5870202pll.6 for ; Fri, 02 Dec 2022 14:18:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=illuminatedcomputing-com.20210112.gappssmtp.com; s=20210112; h=subject:from:to:content-language:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=562JSaVDt62a/P4F4wfRtGsMFCxX+0lqzLmt0fctkrM=; b=h+Um+cIPZLx/txzJz84oWo6iTRZng7XpoI+n5Uv6g21ipH6XnQO5vlSvCCx60mGj01 aqkvr7/r5gPDMXgb8xUYLU+S7iqHkoicARv5xmx1G6xVso96N6A5trkmF58/216B8Orx 74U62ueM+Sxnw/xWNUyIrfAJ3LTMd1JnKYgXtc7hSFSj9hxUiY9hzZGgpKX9cPM9pNap 4IOqxeNsHx5DNmXo3wt/uQ2SsyAx8nUP+P6tNkXs0SFQrfioPqsVc68fi9yMwtnUoy7a 5nlyOV1mxzc9A6iVQH+poXj7oUI7w19uDBDyF81sr13xVHqZqprmliOSrhtc8S+Ldvd+ Zd8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=subject:from:to:content-language:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=562JSaVDt62a/P4F4wfRtGsMFCxX+0lqzLmt0fctkrM=; b=YVLZ1V4QDSeKB35X/EjX8+oVCK3VY6u8tmYmxkxlar5WtWIGD3dxYFl3XfsOj3ydnb mNAIdpLTYRDugQzjLCrkEdPPCmBKdLpr/aNTJ8kjTZ45NS2ne/tKEg84pP/B5UUYky6z 2dIkDtH00cbwOlgODT6LwvmO24d1lq6MJ0BNBR5OW876u/3NO5ktRueK247/+s+5oiZ3 oCS7Qp2kF+qVEWPZrPCegrcAYIepnlhAa3ERE/l4p9Ru/cNMQD1cIFWq+wtBUdHI5HLU GZc4pOXWAEOIGgQZyjF36YOvF7r2BAsVdWmOaPsmtg7IujK9u6cZ7w1djGqGMeIzaQj4 GWGg== X-Gm-Message-State: ANoB5pmNErxQhLXmYNttY7N4BLFzQgOZzm/H0RyRt1A3Lp+A8PXWTs7g MhILrGv9wFTCYsQfZKNBIKMXx1JTtbUWq/9m X-Google-Smtp-Source: AA0mqf5+N79ysyC75ZKxnaiXhxAioveSLqCfH1lVQA1IDbNs+M8BFbukbRowyhr4WY8vECRa8/2agg== X-Received: by 2002:a17:903:3281:b0:189:b74e:cbf7 with SMTP id jh1-20020a170903328100b00189b74ecbf7mr7582701plb.29.1670019533216; Fri, 02 Dec 2022 14:18:53 -0800 (PST) Received: from [192.168.2.139] ([50.53.98.191]) by smtp.googlemail.com with ESMTPSA id b11-20020a1709027e0b00b0018957322953sm6022254plm.45.2022.12.02.14.18.52 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 02 Dec 2022 14:18:52 -0800 (PST) Content-Type: multipart/mixed; boundary="------------FEVHJLOP13tAngGim8SgKqiT" Message-ID: <6a7c7338-1aa2-4689-d171-0b0b294fdd84@illuminatedcomputing.com> Date: Fri, 2 Dec 2022 14:18:51 -0800 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Content-Language: en-US To: Pgsql Hackers From: Paul Jungwirth Subject: Think-o in foreign key comments List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------FEVHJLOP13tAngGim8SgKqiT Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hello, I noticed a few places in the new foreign key code where a comment says "the ON DELETE SET NULL/DELETE clause". I believe it should say "ON DELETE SET NULL/DEFAULT". These comments were added in d6f96ed94e7, "Allow specifying column list for foreign key ON DELETE SET actions." Here is a patch to correct them. I don't think you usually create a commitfest entry for tiny fixes like this, right? But if you'd like one please let me know and I'll add it. Yours, -- Paul ~{:-) pj@illuminatedcomputing.com --------------FEVHJLOP13tAngGim8SgKqiT Content-Type: text/x-patch; charset=UTF-8; name="v1-0001-Fix-FK-comment-think-o.patch" Content-Disposition: attachment; filename="v1-0001-Fix-FK-comment-think-o.patch" Content-Transfer-Encoding: base64 RnJvbSBkYzVlMzE3NzYyMjY2YjkzYmZhNDRiYjMwM2ZlMTg4Mjg1M2Q4ZGU3IE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiAiUGF1bCBBLiBKdW5nd2lydGgiIDxwakBpbGx1bWlu YXRlZGNvbXB1dGluZy5jb20+CkRhdGU6IEZyaSwgMiBEZWMgMjAyMiAxNDowMjo1NSAtMDgw MApTdWJqZWN0OiBbUEFUQ0ggdjFdIEZpeCBGSyBjb21tZW50IHRoaW5rLW8KCi0tLQogc3Jj L2JhY2tlbmQvY29tbWFuZHMvdGFibGVjbWRzLmMgfCA4ICsrKystLS0tCiAxIGZpbGUgY2hh bmdlZCwgNCBpbnNlcnRpb25zKCspLCA0IGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL3Ny Yy9iYWNrZW5kL2NvbW1hbmRzL3RhYmxlY21kcy5jIGIvc3JjL2JhY2tlbmQvY29tbWFuZHMv dGFibGVjbWRzLmMKaW5kZXggM2U4M2YzNzViNS4uNzE2NzkzZTE1NyAxMDA2NDQKLS0tIGEv c3JjL2JhY2tlbmQvY29tbWFuZHMvdGFibGVjbWRzLmMKKysrIGIvc3JjL2JhY2tlbmQvY29t bWFuZHMvdGFibGVjbWRzLmMKQEAgLTk0NjcsMTAgKzk0NjcsMTAgQEAgdmFsaWRhdGVGa09u RGVsZXRlU2V0Q29sdW1ucyhpbnQgbnVtZmtzLCBjb25zdCBpbnQxNiAqZmthdHRudW1zLAog ICogbnVtZmtzIGlzIHRoZSBudW1iZXIgb2YgY29sdW1ucyBpbiB0aGUgZm9yZWlnbiBrZXkK ICAqIHBrYXR0bnVtIGlzIHRoZSBhdHRudW0gYXJyYXkgb2YgcmVmZXJlbmNlZCBhdHRyaWJ1 dGVzLgogICogZmthdHRudW0gaXMgdGhlIGF0dG51bSBhcnJheSBvZiByZWZlcmVuY2luZyBh dHRyaWJ1dGVzLgotICogbnVtZmtkZWxzZXRjb2xzIGlzIHRoZSBudW1iZXIgb2YgY29sdW1u cyBpbiB0aGUgT04gREVMRVRFIFNFVCBOVUxML0RFTEVURQorICogbnVtZmtkZWxzZXRjb2xz IGlzIHRoZSBudW1iZXIgb2YgY29sdW1ucyBpbiB0aGUgT04gREVMRVRFIFNFVCBOVUxML0RF RkFVTFQKICAqICAgICAgKC4uLikgY2xhdXNlCiAgKiBma2RlbHNldGNvbHMgaXMgdGhlIGF0 dG51bSBhcnJheSBvZiB0aGUgY29sdW1ucyBpbiB0aGUgT04gREVMRVRFIFNFVAotICogICAg ICBOVUxML0RFTEVURSBjbGF1c2UKKyAqICAgICAgTlVMTC9ERUZBVUxUIGNsYXVzZQogICog cGYvcHAvZmZlcW9wZXJhdG9ycyBhcmUgT0lEIGFycmF5IG9mIG9wZXJhdG9ycyBiZXR3ZWVu IGNvbHVtbnMuCiAgKiBvbGRfY2hlY2tfb2sgc2lnbmFscyB0aGF0IHRoaXMgY29uc3RyYWlu dCByZXBsYWNlcyBhbiBleGlzdGluZyBvbmUgdGhhdAogICogd2FzIGFscmVhZHkgdmFsaWRh dGVkICh0aHVzIHRoaXMgb25lIGRvZXNuJ3QgbmVlZCB2YWxpZGF0aW9uKS4KQEAgLTk2ODYs MTAgKzk2ODYsMTAgQEAgYWRkRmtSZWN1cnNlUmVmZXJlbmNlZChMaXN0ICoqd3F1ZXVlLCBD b25zdHJhaW50ICpma2NvbnN0cmFpbnQsIFJlbGF0aW9uIHJlbCwKICAqIHBrYXR0bnVtIGlz IHRoZSBhdHRudW0gYXJyYXkgb2YgcmVmZXJlbmNlZCBhdHRyaWJ1dGVzLgogICogZmthdHRu dW0gaXMgdGhlIGF0dG51bSBhcnJheSBvZiByZWZlcmVuY2luZyBhdHRyaWJ1dGVzLgogICog cGYvcHAvZmZlcW9wZXJhdG9ycyBhcmUgT0lEIGFycmF5IG9mIG9wZXJhdG9ycyBiZXR3ZWVu IGNvbHVtbnMuCi0gKiBudW1ma2RlbHNldGNvbHMgaXMgdGhlIG51bWJlciBvZiBjb2x1bW5z IGluIHRoZSBPTiBERUxFVEUgU0VUIE5VTEwvREVMRVRFCisgKiBudW1ma2RlbHNldGNvbHMg aXMgdGhlIG51bWJlciBvZiBjb2x1bW5zIGluIHRoZSBPTiBERUxFVEUgU0VUIE5VTEwvREVG QVVMVAogICogICAgICAoLi4uKSBjbGF1c2UKICAqIGZrZGVsc2V0Y29scyBpcyB0aGUgYXR0 bnVtIGFycmF5IG9mIHRoZSBjb2x1bW5zIGluIHRoZSBPTiBERUxFVEUgU0VUCi0gKiAgICAg IE5VTEwvREVMRVRFIGNsYXVzZQorICogICAgICBOVUxML0RFRkFVTFQgY2xhdXNlCiAgKiBv bGRfY2hlY2tfb2sgc2lnbmFscyB0aGF0IHRoaXMgY29uc3RyYWludCByZXBsYWNlcyBhbiBl eGlzdGluZyBvbmUgdGhhdAogICoJCXdhcyBhbHJlYWR5IHZhbGlkYXRlZCAodGh1cyB0aGlz IG9uZSBkb2Vzbid0IG5lZWQgdmFsaWRhdGlvbikuCiAgKiBsb2NrbW9kZSBpcyB0aGUgbG9j a21vZGUgdG8gYWNxdWlyZSBvbiBwYXJ0aXRpb25zIHdoZW4gcmVjdXJzaW5nLgotLSAKMi4y NS4xCgo= --------------FEVHJLOP13tAngGim8SgKqiT--