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 1tzfuC-0054K1-HW for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Apr 2025 18:00:08 +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 1tzfuA-004qpf-Vg for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Apr 2025 18:00:06 +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 1tzfuA-004qo9-M4 for pgsql-hackers@lists.postgresql.org; Tue, 01 Apr 2025 18:00:06 +0000 Received: from mail-lf1-x133.google.com ([2a00:1450:4864:20::133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tzfu8-002OGl-2P for pgsql-hackers@postgresql.org; Tue, 01 Apr 2025 18:00:05 +0000 Received: by mail-lf1-x133.google.com with SMTP id 2adb3069b0e04-549b116321aso6816999e87.3 for ; Tue, 01 Apr 2025 11:00:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743530403; x=1744135203; darn=postgresql.org; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=vjYYv4wle2XKsIbIoqvSdCLqQbM26ReOoerDOap3kAI=; b=Vz3GoPQViAdfKVJYH7jX0DAuBiMoJKVC3TE2ZlU+B8+6/8yG1YM9AytozU6pLOlgv9 Myf3oDw65sbB/IxmG8LDpvR43xEDzpBa9UxSuanlj9nqUaC4Uh9i+1oC5zfDelCx4VXT wGyDFhGD3evlJM/kVNydxATyH254udwPzMxUk2P5c2sY5b73EKUInXMsT9FowSYqgkIG NOUPdlTsfM/1KO+9DgQdGjrVsZZU0cPbZPoJ6XPqFqSVWv9dhU1jmki+eqERvQLvuUeL O+qiHJIQQgHr9UAVGrZB0RNh53QmGpRANld41aUDASXaG9QOy+pJoSlDU9BM/lYi+ssY GHkg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743530403; x=1744135203; h=in-reply-to:from:content-language: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=vjYYv4wle2XKsIbIoqvSdCLqQbM26ReOoerDOap3kAI=; b=O3sz3R+gqeA82W//CJL9sQjTkaeVaSd6iKYU+BKjr2Lljf/OYjYwoU8Kr6haew3pDz bl0tt1U3CYOBhEt77O+o7a0hi1SGVCPdMsyg3yNbKLItJHXB9gPvYgS3rsbgllzB9SXL IbV1Woj4ZBOnfCE9DlQIT9jumoBt1R042LXmrG91Ll2G23jOVG4p9rCLfojwW0q4qRqd Gp29aRZSzFE7La7e6iruK1lmW7G7fFFjdVJD7uzQXRIvwcdwkkithDPFh6z0lMC1y+Vw qUOXSh9+MrV2sNi+4IGRIlmvrn0ap8LX1wqd9en5OBmqIfQTtOgVLvKFIi0vTF6Gb7O/ Fgew== X-Gm-Message-State: AOJu0YxXDh5sFP+OdJ86EGoTJgKEytZEUR021s56iaKjgK733Im1YSTK Q/bGMu0rkOHrC22LBQozNt4CqpYB6wTpmpMbyLmel3gOPYVJnNiXEXLFrQ== X-Gm-Gg: ASbGnctmBQDrdOUZqkZoROhR0ZTz6FKMwwS04KZOrAfB0wMlAhCgr2YhjG9yzrGWgH+ X7m6Mu65bijjDKkkt+RyLdNPWBUFVOnxRRg18Zy/mwebE5y2anKA4Q73VdQxV37Lf3GVrceM43Q sl2lt8cHbsvIr+wIzcwAztHvVmDEV/1zhWpbaecgZVyV18LAVZbPfCUSGXjq67oU5KKCaiS0XH3 YRNn/b+fh33l1Ft7fWn330oXmiX7W+2CmRq8X4f6zpXxLJ0RGeKYpbKrTcS4JRGTPNZH13h6X7R unfP9o0mlLOQTks9fZ1m2XWcb8/80FoZCBDVWW4PsnBDcVd+8d6MoXW9Iw== X-Google-Smtp-Source: AGHT+IG0/0l563S9EAIFpxqVRGI8vKSx89vMzFs6jVYhuPz93zHmn0ZYskhWxiC/Yk683K0x/oVszQ== X-Received: by 2002:a05:6512:3ca4:b0:549:9143:2609 with SMTP id 2adb3069b0e04-54b10dba35bmr4872077e87.3.1743530402876; Tue, 01 Apr 2025 11:00:02 -0700 (PDT) Received: from [192.168.0.50] ([89.149.68.176]) by smtp.gmail.com with ESMTPSA id 2adb3069b0e04-54b094c1a58sm1437169e87.99.2025.04.01.11.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 01 Apr 2025 11:00:02 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------pExxObeGfKBo6tPDQimCsirp" Message-ID: <025a3ffa-5eff-4a88-97fb-8f583b015965@gmail.com> Date: Tue, 1 Apr 2025 21:00:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: bug when apply fast default mechanism for adding new column over domain with default value To: Tom Lane , jian he Cc: PostgreSQL-development References: <2901599.1740811424@sss.pgh.pa.us> <3086966.1740873261@sss.pgh.pa.us> <3519325.1740953319@sss.pgh.pa.us> <3664075.1741018726@sss.pgh.pa.us> <4060266.1741027118@sss.pgh.pa.us> Content-Language: en-US From: Alexander Lakhin In-Reply-To: <4060266.1741027118@sss.pgh.pa.us> 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. --------------pExxObeGfKBo6tPDQimCsirp Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hello Tom, 03.03.2025 20:38, Tom Lane wrote: > Pushed with that adjustment and some other minor polishing. I've discovered that 95f650674 introduced a defect similar to bug #18297, but this time with DEFAULT. Namely, the following script: CREATE TABLE a (aa text); CREATE TABLE c (cc text) INHERITS (a); CREATE TABLE d (dd text) INHERITS (c, a); ALTER TABLE a ADD COLUMN i int DEFAULT 1; fails with: ERROR:  XX000: tuple already updated by self LOCATION:  simple_heap_update, heapam.c:4421 Best regards, Alexander Lakhin Neon (https://neon.tech) --------------pExxObeGfKBo6tPDQimCsirp Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
Hello Tom,

03.03.2025 20:38, Tom Lane wrote: 
Pushed with that adjustment and some other minor polishing.

I've discovered that 95f650674 introduced a defect similar to bug #18297,
but this time with DEFAULT. Namely, the following script:
CREATE TABLE a (aa text);
CREATE TABLE c (cc text) INHERITS (a);
CREATE TABLE d (dd text) INHERITS (c, a);
ALTER TABLE a ADD COLUMN i int DEFAULT 1;

fails with:
ERROR:  XX000: tuple already updated by self
LOCATION:  simple_heap_update, heapam.c:4421

Best regards,
Alexander Lakhin
Neon (https://neon.tech) --------------pExxObeGfKBo6tPDQimCsirp--