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 1rVvxb-002DBc-Ac for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Feb 2024 16:00:11 +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 1rVvxY-00EJpL-8A for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Feb 2024 16:00:08 +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 1rVvxX-00EJoT-Tt for pgsql-hackers@lists.postgresql.org; Fri, 02 Feb 2024 16:00:07 +0000 Received: from mail-lf1-x134.google.com ([2a00:1450:4864:20::134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rVvxV-004jEB-KD for pgsql-hackers@lists.postgresql.org; Fri, 02 Feb 2024 16:00:06 +0000 Received: by mail-lf1-x134.google.com with SMTP id 2adb3069b0e04-5113a8c01acso527633e87.2 for ; Fri, 02 Feb 2024 08:00:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1706889604; x=1707494404; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=w7w//MpczAqGHjfATOAdpfb6U4eECVm4ADe44g0TvP4=; b=CtDvvNk2CQPs9wCDC/UO3nFpt8BAM9aTjzbmcrtwyfUTDkoqN6G/1HjavOXos193C5 TWBbIMCDvgQ4nBGMtZfs7DDZ+nEfgdZM2TtWLg2aR2Ursm6s8YiWgEMwPUofsz/sbgjY 0hY4MBrH70FF6+dlW42qxxTv9VexOo8qlc4TTcj97veN0TnnV2i9xJSjpzdrzTu1dOWe PUQlZwwXhU6eousyiXUXAP/po5TeyqXt6Xxuo3MR9kBpUeODgbhEKscrZ0cGFZBCjYa/ lSWzE6JUbTF69ln3y03+v4jCLauHO9eUXoeK4E7qFSc+ugIItL36gdb7Vmoihyi/SEXI +SYw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1706889604; x=1707494404; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=w7w//MpczAqGHjfATOAdpfb6U4eECVm4ADe44g0TvP4=; b=b176YNBUIvYNIHrjv4HhtJzGllYoITpEYDp+VdP6PMOPuu9wQEGf0diDVLgIsWgEKC x+xHyLKkRbIcTpoAI5KkrBxXsRQQ5D5M8G9fiMz/uXgAdIN5OzEQOUDBTwvMJCanUJwt q0Dz4Q0CD7iIO/2fAIZHNB6HLRjfaE5bafBuu2NoB8V6jxOzBrs7xhoFBFOGKNC9gNt1 bOFE0xP006GsPLINNWIEOLm38D7NCXlFU12x/67YBw/GZsMcmrJXJArm+dYbxYDevGOE VkLXPPxtEuKz+gJV/hE0TgX4BoyQjEvJhV2RSZnm5+CtxuWL4lgjb28cQ/otkR0MpuPS FUVQ== X-Gm-Message-State: AOJu0YyL3oupFCO8ctKiXZQnMCNVjhYtw+SeheKZ9O2vXN/riqyqkSug t4337LfHskO+4Lgp2LZkt7b0/RnU4vmH72kXrn62A4tQCfKF7/0B X-Google-Smtp-Source: AGHT+IGQKkkvC5d3t0LXsegsqFfgzkU5oamQic20nIEreJnj5d/o4fHzwaqzi5pVa2AegPvYpdgI3g== X-Received: by 2002:a05:6512:3e10:b0:511:2ed4:d7aa with SMTP id i16-20020a0565123e1000b005112ed4d7aamr1658929lfv.35.1706889603746; Fri, 02 Feb 2024 08:00:03 -0800 (PST) X-Forwarded-Encrypted: i=0; AJvYcCVQKAMEW9aLpphZIadwY/spC2V+q5Yn/95egmyX+uL6eUELEcrTRvu0cYMEN5YAs7gNh+nSMWNCMRbwFrEiIaZM/E2ltxcEBCEAjzaF52+7aevhlGc4S/ff6HIfEpSds3ELO4pAyD7u6ZeGLv5i2hG2GGZqd3LV9CBZZAVG75dV Received: from [1.0.0.7] ([91.185.77.50]) by smtp.gmail.com with ESMTPSA id m15-20020a056512014f00b0051022c3a76dsm339092lfo.177.2024.02.02.08.00.02 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 02 Feb 2024 08:00:02 -0800 (PST) Message-ID: <045dec3f-9b3d-aa44-0c99-85f6992306c7@gmail.com> Date: Fri, 2 Feb 2024 19:00:01 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: cataloguing NOT NULL constraints Content-Language: en-US To: Alvaro Herrera Cc: Dean Rasheed , Peter Eisentraut , Robert Haas , pgsql-hackers@lists.postgresql.org References: <202311081753.paidc6czdtmr@alvherre.pgsql> From: Alexander Lakhin In-Reply-To: <202311081753.paidc6czdtmr@alvherre.pgsql> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello Alvaro, Please look at an anomaly introduced with b0e96f311. The following script: CREATE TABLE a (); CREATE TABLE b (i int) INHERITS (a); CREATE TABLE c () INHERITS (a, b); ALTER TABLE a ADD COLUMN i int NOT NULL; results in: NOTICE:  merging definition of column "i" for child "b" NOTICE:  merging definition of column "i" for child "c" ERROR:  tuple already updated by self (This is similar to bug #18297, but ATExecAddColumn() isn't guilty in this case.) Best regards, Alexander