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 1qbfPI-00ChsD-7p for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Aug 2023 11:00: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 1qbfPG-0062xf-2G for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Aug 2023 11:00: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 1qbfPF-0062xX-Nn for pgsql-hackers@lists.postgresql.org; Thu, 31 Aug 2023 11:00:09 +0000 Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qbfPB-00278M-D2 for pgsql-hackers@lists.postgresql.org; Thu, 31 Aug 2023 11:00:08 +0000 Received: by mail-lj1-x22d.google.com with SMTP id 38308e7fff4ca-2b962535808so13040891fa.0 for ; Thu, 31 Aug 2023 04:00:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1693479603; x=1694084403; 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=C+hIj5fX7hGX/3vNt972+1pCxDM3yROD5wHaSbo47j8=; b=ARrGQk8T/CD/2M0BXwFl2X874u/PVBF9XxIZKA4Kp/3Fnf/5t+jNLYINjRq1DBCZpP S6s6WoZ8HPAd7Gg5pBc6AeXTrtCRhAt/ql3y0ppCRZMcIh10ywvfg9XQmbeQAN0/LJzm hq00kCka9uJCkvcT6jqg5HFsEeT+oI+fDXA1Y8oqw5Jo80CUqJELRrYxX4HhpUZKsx5M ePnTTUy0ExKg5OPX/hHEIbNP0/hw1tWSdApElsl2yhROQgkSn/TcAgi7p1U6nj5uwQ7I Bq+UY3BMW662Ky9KHAsEJLeAf/+KMfeNqL7NNI2D/3JWxlunBkhnIO87Sptz+sWnGhlq wJ6Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693479603; x=1694084403; 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=C+hIj5fX7hGX/3vNt972+1pCxDM3yROD5wHaSbo47j8=; b=a3FQ8YtHsv5NEt07nV4BAq2+If6iDrCEACa1wnlCAXTi234iiDoxCmbEG1GtPckVGn 86tGz1wlaVzserT/CvKmX5R0wyZ09veozEE2QXFnu2V19NlaiWenaziUlfE1cT2xshvA o26rp3jzfcAnspE3gSIT4Fdy+5Xwl66k49cJmxfejvj2cVrrZwYmTjVu9FN68q/ksqWT o/5t+ZmlyuGygFYc0/Ny+X1y7iRhJGJ8XknFsAdExAfPbruF2ZG9Wa7Wv5yL+Rati/tW Aj1pIlhlFHWxqk+2SgjKKqfgeytOQp8Fp/8WU7d5grQ3pcbVHoDzvtRR7mHDquhcdW3L Kx7g== X-Gm-Message-State: AOJu0YzlRx71FkKH0fSZ+dTscMj2QN7tecbFrr69oyIY/gedT02rG1F7 TqmDQGKEnUJ4LZKIT6dMVJQ= X-Google-Smtp-Source: AGHT+IEJIGKRKumpvnm7mXcPN/uNINRNH6D0unfIfsgRsvV5CGClpvzcPGublb0xpAl8DNTsDCovPg== X-Received: by 2002:a05:6512:3e09:b0:500:8f65:c624 with SMTP id i9-20020a0565123e0900b005008f65c624mr4435358lfv.53.1693479602631; Thu, 31 Aug 2023 04:00:02 -0700 (PDT) Received: from [1.0.0.7] ([178.155.31.218]) by smtp.gmail.com with ESMTPSA id x12-20020ac2488c000000b005007fc9ccccsm209331lfc.122.2023.08.31.04.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 31 Aug 2023 04:00:01 -0700 (PDT) Message-ID: Date: Thu, 31 Aug 2023 14:00:00 +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: <20230831102647.zf7q6j77ivn66jr6@alvherre.pgsql> From: Alexander Lakhin In-Reply-To: <20230831102647.zf7q6j77ivn66jr6@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 31.08.2023 13:26, Alvaro Herrera wrote: > Hmm, that's some weird code I left there all right. Can you please try > this patch? (Not final; I'll review it more completely later, > particularly to add this test case.) Yes, your patch fixes the issue. I get the same error now: ERROR:  column "a" in child table must be marked NOT NULL Thank you! Best regards, Alexander