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 1tl6Gi-009InT-6t for pgsql-general@arkaria.postgresql.org; Thu, 20 Feb 2025 13:07: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 1tl6Gg-006RnW-20 for pgsql-general@arkaria.postgresql.org; Thu, 20 Feb 2025 13:07:06 +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 1tl6Gf-006RnL-Nq for pgsql-general@lists.postgresql.org; Thu, 20 Feb 2025 13:07:05 +0000 Received: from mail-oa1-x33.google.com ([2001:4860:4864:20::33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tl6Gd-001xmE-1Z for pgsql-general@lists.postgresql.org; Thu, 20 Feb 2025 13:07:05 +0000 Received: by mail-oa1-x33.google.com with SMTP id 586e51a60fabf-2bc5212b2easo383334fac.1 for ; Thu, 20 Feb 2025 05:07:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740056821; x=1740661621; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=ZVy9MK17k+X4tf6xU5KqzK4G7jsxNS7rJVGVlMsWTZc=; b=JId6QGTpskmz/7ft5KrWKrLKo6csGk/dh+ArEqd2IAJ1VlhnEGKpZdP4cXvfatuNu1 XUxDY3qLemzEiYit6UVrV3nxP0suJQIvmw0BbHwJMpJIrcD70p8JZ5P1dQcPb+l4nifB NgcQIu/TICe00tm/RL3t55rTPpvJHXNyrU+Bu7kQDyzn7iYrHVxXPst4jR5Kri0oBPqi i9XkcXYXdCfs5hJBSQP+j7RdOl/y2lo0zYtxJxFzSjvwqjDyAtkrWdZObs5Q8he86dZ8 vDbvjMa8FY88QYTbzqS2XMW4uy7bJghukAoblItJ3tshbog8mV4Z9RcIqcm1zMjYoA+5 EETw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740056821; x=1740661621; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=ZVy9MK17k+X4tf6xU5KqzK4G7jsxNS7rJVGVlMsWTZc=; b=HWwPjM6PaPZdnxnKM7OQJd5vPQk+A3/3BFOfrLVXJMprD7jG3yA8t+UDrtvZo8xUd2 idtt99o8qpOV2ygI5BzlPNm1f3kuk9xY/5vbTOZR9Ag9zqDiEbZSWA3kZ41wZJ2tJ6cj gaBFrjj2tisAQiLQm2nL9Ad4xpYdVgDd57/2jCulc/kJNiMDbPHhxs3hjW6S/2QT3+80 lJEsPH+RfChVP1w/L7N9kH2hON7syVGgP4adhzbfwjQI30j/WGyuyUQBSsH7/LaFx+gg eGzfNlMaHtv4XIC2jGQp8IL6rcoAeiNSZDvDrYhmkSEUJUGNJgGrTOWikSjoNDnFTUI6 L5ng== X-Gm-Message-State: AOJu0YxbNGScrkzjX+csp8KnSo8YaidBaMg5V3Weo8ACDCp/iKDCFzLB ytTcr/ZA/nKqAZUnzcogI/Bp7Iz2L9L/j5g9tfL1ezFRJWnUz0XPlyzdMulJnPh01eGWng0z5DI mYsVN3ia6u3SXN4ILpZoFMIVRybNnXIB4 X-Gm-Gg: ASbGncsNzQRg+gCIzWlSHQ9z0qMMc/ulUxAbDMZ4aS21RDCYZMXjXvH+6afehwJvTqd fOxARV5E1FizGY4+VWeex0qvDVD4PYdTODWo3f1VEDeq6dPrHQlXRp7vaFEWVUodH5BdftT9qc0 g= X-Google-Smtp-Source: AGHT+IGu6R9ExAxb9KwIMFmSfmfFMwfLLaKGoFso3ERIrFNMggZ1wrR0eosTHd3lsXIu9+95JozePvJjtoBACb7afmI= X-Received: by 2002:a05:6870:c0d0:b0:29d:c624:7c3d with SMTP id 586e51a60fabf-2bd1045f9c8mr6104099fac.32.1740056820421; Thu, 20 Feb 2025 05:07:00 -0800 (PST) MIME-Version: 1.0 From: Dominique Devienne Date: Thu, 20 Feb 2025 14:06:45 +0100 X-Gm-Features: AWEUYZkeqe7yK5CFFYaX6og9wML5DFV4pP5AQFk7Zd3D6bXLn4Lf3QxUsu40sN8 Message-ID: Subject: v18 virtual columns To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000ab9fb8062e928cf9" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ab9fb8062e928cf9 Content-Type: text/plain; charset="UTF-8" Hi. I've just read https://www.dbi-services.com/blog/postgresql-18-virtual-generated-columns/ and I'm wondering whether there will be a way to ALTER existing STORED generated columns, to be virtual? W/o rewriting the whole table that is. Thanks, --DD --000000000000ab9fb8062e928cf9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi. I've just read=C2=A0https://www.dbi-se= rvices.com/blog/postgresql-18-virtual-generated-columns/

=
and I'm wondering whether there will be a way to ALTER existing ST= ORED generated columns, to be virtual? W/o rewriting the whole table that i= s.

Thanks, --DD
--000000000000ab9fb8062e928cf9--