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 1ssolp-00B8nW-2t for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Sep 2024 19:30:53 +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 1ssoln-00DxUI-CR for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Sep 2024 19:30:51 +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 1ssolm-00DxUA-VM for pgsql-hackers@lists.postgresql.org; Mon, 23 Sep 2024 19:30:51 +0000 Received: from mail-qk1-x730.google.com ([2607:f8b0:4864:20::730]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ssolj-000gyf-PR for pgsql-hackers@postgresql.org; Mon, 23 Sep 2024 19:30:49 +0000 Received: by mail-qk1-x730.google.com with SMTP id af79cd13be357-7a9aec89347so300364285a.0 for ; Mon, 23 Sep 2024 12:30:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1727119845; x=1727724645; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=AmlKMriHEnL2QffChBHUiXCTuF+hn+LHoU/hI06LDBA=; b=VlKZnsFs+9EREkOQit6vmozOvc8fLy0WVy1EEjLCKnrA2HTgjz9Ws5cUNp0ZjtSBj9 3QP0aGd9ycJyHrF+DpUV8hp0MpoYbWl3+eR0KkGRq+cLGY3oq70Y+yQ/+1ElAJGrYUt8 vGr7IWVgcfaNBttfqHgc+8c2kU1lQsfgtqZ3T47mlzBxvO6zqFxwKWj0f2tjqtsW0yZK dg2RVEtqnrsw6RFNSl3+QCqTVoQdb/a+U4Dds7Hbm+KeigszZRxlNMcoAZLXlg8VHYiK pDDm2mu8Zm9mAEQG8KOp2PvVEjG0rbk3ulx9xPeC+VHXVI8AcD+rpxOFDjmLiWRG7LAB FX6g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727119845; x=1727724645; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=AmlKMriHEnL2QffChBHUiXCTuF+hn+LHoU/hI06LDBA=; b=l3bQ3A6zTej+umGE0H8JN6qrYA2AqwpMRoL4x9JpzIEnOCdgD5G9P0C/aBqnpQqb5Y qbc8wyX830iS469ntp6XwCWzYsMxUD3Co9xEDdd/4MWIygnn0s9LtI9OaVnUqb7BpS6R qvxgg4MwvikAdySv1J5QFG1hNXm5GQypp+6RL+LoUraw8Ng4yaILYbPeCy2FKPCjit3e dAxw4eXwMbXmDA4actiMqLP5dyxQ4xLIE1k4qVfwFlbstu0/cNy5NtiE3WZ9j9q+3j7i ILQZUkd5HiZAK+Meybw0yjpRrCgLRf1U9lfXiM+SQBXO4MUxu/6FOxrkU63F3lEiPMUm dD/w== X-Forwarded-Encrypted: i=1; AJvYcCUn1pe1fpt6kggz5f+yZKtPc0uCRnSPBrfsAoNnQ9frVJyFmavAPzk+isJt5oGYC21Nj15Ri9Ivm/RSV1We@postgresql.org X-Gm-Message-State: AOJu0Ywz1L/9gwikGaNN5qUN96mptYgHg9r8a0mrO92pO1PPHeA8bCK/ trGzk//0kO8nP06PadtlaSJhd3AajjuqedjbyewO7QHQdTPfXmFjGUzYV/bca/U= X-Google-Smtp-Source: AGHT+IFrfqX9Oc4ZF/dqzGqKHoPLj+pXd5qG+xD69V0zJ47JKQfhMyF64v/4h+s2N0a1uPA5lXD43Q== X-Received: by 2002:a05:620a:4105:b0:79f:793:9a63 with SMTP id af79cd13be357-7acb8ddba9amr1769705385a.44.1727119845456; Mon, 23 Sep 2024 12:30:45 -0700 (PDT) Received: from ?IPV6:2605:a601:9180:9800::2bb? ([2605:a601:9180:9800::2bb]) by smtp.googlemail.com with ESMTPSA id af79cd13be357-7acb07e1394sm516402085a.14.2024.09.23.12.30.43 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 23 Sep 2024 12:30:44 -0700 (PDT) Message-ID: Date: Mon, 23 Sep 2024 15:30:42 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: attndims, typndims still not enforced, but make the value within a sane threshold To: Tom Lane , Michael Paquier Cc: Junwang Zhao , jian he , PostgreSQL-development References: <1807434.1726668657@sss.pgh.pa.us> <2358226.1726807096@sss.pgh.pa.us> From: Andrew Dunstan Content-Language: en-US Autocrypt: addr=andrew@dunslane.net; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAmwQTAQgARQIbAwIX gAIZAQULCQgHAgMiAgEGFQoJCAsCBBYCAwECHgcWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUC ZFlxxwUJGVGAbgAKCRCZ+n/LWfw7gXikB/9ZdcUy6CTBFIIuL/bVsc1eLEW/gJBjJBF6HxNY xgEkAgXAp4Lg4A5U+QB9GouFr7+GYxF0BU4hzoGhNPUWltxnHdMWP8nC/38LAqgMi8L/bbsm HW5YPBdWYaAZAPJQVfOAgjTbRUb26KSprpyrrJKW0ZmrZfjhNPcQ72jpWzoPLQqx2X6B0fru 1jq+cBh8lb6r1mJTim1T3JIn+F/v5VpdQS+EL8xqsHkfzKjIPsW3CIXpkypSk6saA55Rkkbl 26AW8ftPVB0Q6Lnn6FLt9CP0MGNixBQ55yq8r1K+nCBvCCjvQjM8RDm0UUum0WNl+ifQgTLO E8TWEnwVtkBf+3QWzsBNBE7KWFkBCADRnOM0FCzsYW6jtncg+dWIagjUZpvaClmqn/sJluLa Q3v1VXMQJzYs3eC1gh386W+XBwLRpDj3jzH81lX+p73Re3d3oJW7X+ffsxuzu5ZVdMUkqBYo nkAbKxr6gyJ12F/+JkUVzLcoTN+d/7YsQvUVi7NaKH8mJgjz112O4fUe3p9wfAaFa0RXHc5S GPzRTYRRlv/XZBIho4J2tkZOnteZJZ+GbxQVlINt6fd8P6al3MWOvpP/ExJPguEfjOsO6Njy xjo3WfpD4lHMOR/Oc3/8mScEF84rF2jXbsFgelWnbPWAvXY+pD0dXOFRkagGmC/viwBDqq5b 5tk76kKmUbZxABEBAAHCwHwEGAEIACYCGwwWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUCZFlx 5wUJGVGAjgAKCRCZ+n/LWfw7gf+iB/4g8CPY5jihf5r/8EsoIGe2H+dpVmpPF8YGBzTIvCz/ fQoOq8AX/pE76QEuFnFZWfjw+wgBXgCVmkox2Eflkk6z4ND3pcwGZ6CfCxTQCDk/dij+2DQ4 6bmDCy/sBgcbz9mTpoLC11HLoPae6YN9nBNQRZDcEFEu54OaVOqlIdbA6m+POIBCXZdHOFc0 WoDTgxHRzC1jgQNidyd6tKqcsVJs0dzF0oKTmFFmUAqTdJO12LBuNA1rlqrR3EtpYk8B/wtS 5dIMD7Q8hwQpL+4C6GNpb6ZKnPkLi47pDOLhz2qBrqN+rqUEsT3YnExYpzj5yOBi+FlmV1Hw 49QYe1sn2ZPs In-Reply-To: <2358226.1726807096@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024-09-20 Fr 12:38 AM, Tom Lane wrote: > Michael Paquier writes: >> On Fri, Sep 20, 2024 at 11:51:49AM +0800, Junwang Zhao wrote: >>> Should you also bump the catalog version? >> No need to worry about that when sending a patch because committers >> take care of that when merging a patch into the tree. Doing that in >> each patch submitted just creates more conflicts and work for patch >> authors because they'd need to recolve conflicts each time a >> catversion bump happens. And that can happen on a daily basis >> sometimes depending on what is committed. > Right. Sometimes the committer forgets to do that :-(, which is > not great but it's not normally a big problem either. We've concluded > it's better to err in that direction than impose additional work > on patch submitters. FWIW, I have a git pre-commit hook that helps avoid that. Essentially it checks to see if there are changes in src/include/catalog but not in catversion.h. That's not a 100% check, but it probably catches the vast majority of changes that would require a catversion bump. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com