How to  add column 'name' to the film_category table and have it reference category.name in PostgreSQL?

This is using the PostgreSQL dvdrental database

Attempt 1

INSERT INTO film_category(name)

SELECT category.name

FROM category

INNER JOIN film_category

ON category.category_id = film_category.category_id;

ERROR: there is no unique constraint matching given keys for referenced table "category"

4 INSERT INTO film_category (genre) 5 SELECT category.genre FROM category 7 INNER JOIN film_category 8 ON category.category_id = film_category.category_id; 16 Data Output Explain Messages Notifications ERROR: there is no unique constraint matching given keys for referenced table "category" SQL state: 42830