You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
test4=# create table boxes (b box);
CREATE TABLE
test4=# create incremental materialized view v as select * from boxes ;
ERROR: could not identify an equality operator for type box
test4=# create table j (d json);
CREATE TABLE
test4=# create incremental materialized view v as select * from j ;
ERROR: could not identify an equality operator for type json
jsonb can be used.
test4=# create table j2 (d jsonb);
CREATE TABLE
test4=# create incremental materialized view v as select * from j2 ;SELECT0
The text was updated successfully, but these errors were encountered:
Since #92 , we can create IMMV using such base tables, but we cannot insert/delete/update the table, which results in the same error. We should be prevent from creating IMMV at the definition time.
For example, box and json type cannot be used.
jsonb can be used.
The text was updated successfully, but these errors were encountered: