CREATE TABLE t_table (id integer NOT NULL GENERATED ALWAYS AS IDENTITY, part_number integer NOT NULL);
ALTER TABLE t_table ADD CONSTRAINT t_table_pkey PRIMARY KEY (id);

CREATE VIEW t_view AS (SELECT id, part_number FROM t_table WHERE part_number BETWEEN 1 AND 100 GROUP BY id);

SELECT conrelid::regclass::text,conindid::regclass::text from pg_constraint where conname='t_table_pkey';
 conrelid |   conindid   
----------+--------------
 t_table  | t_table_pkey
(1 row)

ALTER TABLE t_table DROP CONSTRAINT t_table_pkey;
ERROR:  cannot drop constraint t_table_pkey on table t_table because other objects depend on it
DETAIL:  view t_view depends on constraint t_table_pkey on table t_table
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

CREATE VIEW t_view_2 AS (SELECT id, part_number FROM t_table WHERE part_number BETWEEN 1 AND 100);

ALTER TABLE t_table DROP CONSTRAINT t_table_pkey;
ALTER TABLE