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 1u7cy7-002kNy-KM for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Apr 2025 16:29:03 +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 1u7cy5-007uHs-Er for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Apr 2025 16:29:02 +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 1u7cy5-007uHk-4T for pgsql-hackers@lists.postgresql.org; Wed, 23 Apr 2025 16:29:01 +0000 Received: from mail-oi1-x231.google.com ([2607:f8b0:4864:20::231]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u7cy3-001Yvf-2v for pgsql-hackers@lists.postgresql.org; Wed, 23 Apr 2025 16:29:01 +0000 Received: by mail-oi1-x231.google.com with SMTP id 5614622812f47-3f6aa4b3a7fso1970499b6e.3 for ; Wed, 23 Apr 2025 09:29:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745425739; x=1746030539; darn=lists.postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=ay6TOV0m7oIXwhpRv6frYlmJt2p4S7DSW7NJLXdwdpw=; b=Rr4Yf91zsnufOtr7Nz9r/G7kCNEjvFTzqmZDFNMgxyzdWRD2WMq6bNcAxhvKc6wc9i lmMyp1vobynajpwBFyfca0cDl+bE750MdF3PcCIGlMIM5IE4ZIZ2bs3tr3VSu+0mEa5R NCyMZ/01sGkHthUObA46dCRSVyOFewrBM77SaQkabBcHYkFEUXGUySMAlWEBB52Y3Cnv Nf2ME0+dbF1luPyobXwysoTy7KQcueMSvoHAsNAClDWJxypn0/cM6LSiveCGGiZYKuRY YIgYIHXHPBFDcL1d5MvQqJ8HKuQWxP58waEuRqKqQ6qKoUZt9KY/ZpPvTpcWv89l0o3I Vb4g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745425739; x=1746030539; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=ay6TOV0m7oIXwhpRv6frYlmJt2p4S7DSW7NJLXdwdpw=; b=mkUzLv+bgwctimkKIQXB8UXw4H9RiJMe6c20OXvN6gPOkGKO0ifuWUdbqTrDftsSVv oTn7iLHZw+bT56KlntS4KYOpTjkVXmyjs+mh6RoH/Qnbo6D37RXS/eU2KBxssrjhkjZL OJivMknkaIc4mTCF4n+3UBLGOGwQFSQEgSIwo+cpeWUrSSQXd86AnGBG1wja48jLxCnc D+IO9APTE2u+GgSUgDzrB6YrqjMwKdnNXSztPDSAPefZTPthxSecBgyxqFrBhe8YJ3Hv xQV01Bjgiy53PwZ34Q0ib19SHwCQu9s15SMqWWse8aD3CKG9hFeG8ZiJDVX3SVND+B9J F2Nw== X-Forwarded-Encrypted: i=1; AJvYcCXMMxqqzq4sGkApKfUU3+hKdiVYL8MIYtmIAFnjfzRGfPa1fQSJahZ/szim/aZJzem5gZDVBYNjDTt/Ini8@lists.postgresql.org X-Gm-Message-State: AOJu0YyEdzyB3Dh1+jn1QkDb/t0E9pH44skJGO6H8s9WLxGRo3AWfSqA fTlJeApgw2gjkRCpH0yOTzWVZutF27V/BnagUGWnZlvWk7gfC0xyHB2lxQ== X-Gm-Gg: ASbGncsP4cfMUNqklYA2Nvhbr1O/ODBz4bf9p1Bgvkxgx+7q4rxDJdodghwVMZzlYoi fbTbauTAl1YnGwCyxThIWTx8FmWfLsEEOavar3aUeGqG7NjfxssC0UD/bX3pvqjfvGUXMPwsIgs 5G76RkjU6wy4OeWEkcpDqDpuPUEHUxpk4KX2lUsafsOHNZp8DCorsJQq6XIJQVeOlIHYX/VXiQO MQX1jJUbe233w4YFor/o1djPLXztkdxvqKo+eWVmSi86CGV76XjOe31gBz9yjIEH1MITAG+FFA5 bm4a7uLM/IAyqvy1/FyfTZ/QD2jd4Jvt2wE/SsQd2e/GNQiDf0ixoaf21+0TUox77pZUdnj97Hi 2g1msmBa/OhK4M5ttPxgMD5KZiHOZ4eM= X-Google-Smtp-Source: AGHT+IGYHjqW/XyYGDR9b/7oP5Y4Xo7HH3mf21xrrInYMRFiZgtvekgQfGZL/1ii7a2FZVIcVPwj3g== X-Received: by 2002:a05:6808:3308:b0:3f6:a476:f7e0 with SMTP id 5614622812f47-401ea5de9dcmr98540b6e.9.1745425739496; Wed, 23 Apr 2025 09:28:59 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-4f6a38066a8sm2918939173.54.2025.04.23.09.28.58 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 23 Apr 2025 09:28:59 -0700 (PDT) Date: Wed, 23 Apr 2025 11:28:57 -0500 From: Nathan Bossart To: =?iso-8859-1?Q?=C1lvaro?= Herrera Cc: jian he , Masahiro Ikeda , Robert Treat , pgsql-hackers@lists.postgresql.org Subject: Re: Doc: fix the rewrite condition when executing ALTER TABLE ADD COLUMN Message-ID: References: <202503241037.pjpyt5j7xrfs@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202503241037.pjpyt5j7xrfs@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This one was briefly discussed in an RMT meeting. On Mon, Mar 24, 2025 at 11:37:20AM +0100, Álvaro Herrera wrote: > On 2025-Mar-24, jian he wrote: > >> In the current development branch, >> virtual generated columns still do not support the domain. >> you can not change the generation expression if it contains a check >> constraint on it. >> so virtual generated columns don't need rewriting. >> >> IMHO, the committed doc description didn't mention this exception. >> we need some text to cover this exception? > > I'd add a note about these two things to the open items page, and wait > to see if we get some of these limitations fixed, so that if we don't, > we remember to note this limitation in the documentation. Are we still waiting on something for this, or should we proceed with the documentation changes? It doesn't seem tremendously urgent, but I noticed it's been about a month since the last message on this thread. -- nathan