-
Notifications
You must be signed in to change notification settings - Fork 736
Open
Description
SELECT row_count, first_row_number FROM columnar.stripe a
WHERE a.storage_id = columnar.get_storage_id('col_table_1'::regclass)
ORDER BY stripe_num;
- row_count | first_row_number
----------------------------------------------------------------------
- 10 | 1
- 12 | 300001
- 1000 | 450001
- 1000 | 451001
- 350 | 452001
-(5 rows)
-
+ERROR: cannot access temporary tables of other sessions
VACUUM FULL col_table_1;
-- show that we properly update first_row_number after VACUUM FULL
SELECT row_count, first_row_number FROM columnar.stripe a
WHERE a.storage_id = columnar.get_storage_id('col_table_1'::regclass)
ORDER BY stripe_num;
- row_count | first_row_number
----------------------------------------------------------------------
- 1000 | 1
- 1000 | 1001
- 372 | 2001
-(3 rows)
-
+ERROR: cannot access temporary tables of other sessions