Skip to content

Could not create IMMV including types which don't have an equality operator #48

@yugo-n

Description

@yugo-n

For example, box and json type cannot be used.

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 ;
SELECT 0

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions