Syntax error at or near “user” when adding Postgres constraint

Ahhh… The word user is a reserved word in Postgres.

Surrounding it in quotes:

alter table indexed_friends add constraint no_duplicate_user_friends unique ("user", friend);

worked.