Details
-
Improvement
-
Status: Resolved
-
Low
-
Resolution: Fixed
-
None
Description
CREATE TABLE users ( id uuid PRIMARY KEY, username text, email text, age int ); CREATE MATERIALIZED VIEW users_by_username AS SELECT * FROM users WHERE username IS NOT NULL PRIMARY KEY (username, id); InvalidRequest: code=2200 [Invalid query] message="Primary key column 'id' is required to be filtered by 'IS NOT NULL'"