Re: Virtual generated columns - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Virtual generated columns
Date
Msg-id 1a754acf-18fe-4f54-bb02-12c674b7f83d@eisentraut.org
Whole thread Raw
In response to Re: Virtual generated columns  (Shlok Kyal <shlok.kyal.oss@gmail.com>)
List pgsql-hackers
On 28.01.25 10:40, Shlok Kyal wrote:
> Test 5: Update publication on non virtual gen with no column list specified
> 
> CREATE TABLE t1 (a int, b int GENERATED ALWAYS AS (a * 2) VIRTUAL);
> create publication pub1 for table t1;
> alter table t1 replica identity full;
> update t1 set a = 10;
> 
> No error is thrown, and an update is happening. It should have thrown
> an ERROR as the unpublished generated column 'b' is part of the
> replica identity.

Thanks, I have fixed that in v14.  (The other 4 tests were correct, right?)



pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: Eagerly scan all-visible pages to amortize aggressive vacuum
Next
From: Tom Lane
Date:
Subject: Re: should we have a fast-path planning for OLTP starjoins?