1

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'
3
  • 2
    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
    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
    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? Jan 18, 2019 at 23:36

1 Answer 1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.