Skip to main content
added code highlighting; added generic platform tag
Source Link
Andriy M
  • 23.2k
  • 6
  • 59
  • 103

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;
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'
Unknown column 'a.row_start' in 'field list'

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'

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'

I'm trying to update the row_startrow_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;

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;

Unknown column 'a.row_start' in 'field list'Error message:

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

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;

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

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'
Source Link

Can you update invisible columns

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;

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