agora inbox for pgsql-hackers@postgresql.org  

help / color / mirror / Atom feed
From: Nathan Bossart <nathandbossart@gmail.com>
To: Paul A Jungwirth <pj@illuminatedcomputing.com>
Cc: jian he <jian.universality@gmail.com>
Cc: Chao Li <li.evan.chao@gmail.com>
Cc: Peter Eisentraut <peter@eisentraut.org>
Cc: SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: FOR PORTION OF does not recompute GENERATED STORED columns that depend on the range column
Date: Tue, 12 May 2026 15:34:18 -0500
Message-ID: <agOOykf2HV26yVfU@nathan> (raw)
In-Reply-To: <CA+renyX4UaO7T=sC2UcpKUwS2yd7zt3XxOm1MgXv5W82ucbk0w@mail.gmail.com>
References: <e856c439-bf96-4244-8dc3-18b2a552e406@eisentraut.org>
	<CA+renyU6rNkiNGreMyQ7pU_F6-5RND5jchHbECH4NoRO7W0Q-Q@mail.gmail.com>
	<27BD5D23-19C9-4FD1-8935-9C788C3C9869@gmail.com>
	<66C1555B-CA54-4ED1-AB4F-0EE97D24A006@gmail.com>
	<91B35E0F-5DC1-4417-A1B9-FAF4A3DCD2BD@gmail.com>
	<CA+renyUBLAynaj0BKhajB6F=sLuitQkjT+_sOt5HBSRn82iQsw@mail.gmail.com>
	<74C1863C-2C2A-423A-BDE7-0228889F1D80@gmail.com>
	<CA+renyUTzwAMar173cbbxJypChp7s=txxgB+LYJQ5oRZ3a5hYQ@mail.gmail.com>
	<CACJufxFHe9iq50RfgyU3T1_CrB+NfdrjdBUp6NFNtb=Dy5Lf-g@mail.gmail.com>
	<CA+renyX4UaO7T=sC2UcpKUwS2yd7zt3XxOm1MgXv5W82ucbk0w@mail.gmail.com>

FOR PORTION OF doesn't seem to work well with virtual generated columns,
either.  The following example seg-faults on my machine:

    create table t (a int, b int4range generated always as (int4range(a, a + 1)) virtual);
    insert into t values (1);
    delete from t for portion of b from 1 to 2;

-- 
nathan





view thread (32+ messages)  latest in thread

Message-ID: <agOOykf2HV26yVfU@nathan>
Permalink:  ../agOOykf2HV26yVfU@nathan/
Also on:    postgresql.org/message-id/agOOykf2HV26yVfU@nathan

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: nathandbossart@gmail.com, pj@illuminatedcomputing.com, jian.universality@gmail.com, li.evan.chao@gmail.com, peter@eisentraut.org, satyanarlapuram@gmail.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: FOR PORTION OF does not recompute GENERATED STORED columns that depend on the range column
  In-Reply-To: <agOOykf2HV26yVfU@nathan>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox