Can you update invisible columns

Question

I'm trying to update the row_start column on a table with Versioning set. The row_start column is invisible.

UPDATE pgwebp.t_prov a
INNER JOIN pgwebp.t_prov b ON a.prov_id_a = b.prov_id 
SET a.row_start = b.system_ts_start;

Error message:

Unknown column 'a.row_start' in 'field list'

Please provide the table definitions of the tables in question so that it can be better understand what is happening. Just giving an update statement doesn't provide enough information. — Joe W, Commented Jan 18, 2019 at 18:37
Seconding what @JoeW said. There are no issues updating an invisible column in general. More details are needed to understand what's going on. — Andriy M, Commented Jan 18, 2019 at 19:15
Table has been set to versioning which creates the row_start and row_end columns. A simple update to these two columns throws the error Unknown column 'a.row_start' in 'field list'; Maybe a better question is can these columns which support versioning, be updated? — Gary Midgley, Commented Jan 18, 2019 at 23:36

danblack · Accepted Answer · 2019-01-21 02:04:00Z

1

This looks like the bug/feature request MDEV-16546.

This pertains to the system versioned tables columns like row_start explicitly as normal invisible columns are currently still updateable.

answered Jan 21, 2019 at 0:37

danblack

8,0092 gold badges12 silver badges28 bronze badges

Add a comment |

1 Answer 1