| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, jian he <jian(dot)universality(at)gmail(dot)com>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
| Subject: | Re: Virtual generated columns |
| Date: | 2025-02-04 22:36:53 |
| Message-ID: | 1a754acf-18fe-4f54-bb02-12c674b7f83d@eisentraut.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-02-04 22:49:58 | Re: should we have a fast-path planning for OLTP starjoins? |
| Previous Message | Peter Eisentraut | 2025-02-04 22:36:09 | Re: Virtual generated columns |