Unable to add foreign key relation
hey guys,
i am creating a profile table for my users, and tried to add a foreign key relation to the key updated_at as it also exists at auth.users.profiles.
but doing that gives me an error: ERROR: 42830: there is no unique constraint matching given keys for referenced table "users"
what can i do?
i later want to use a trigger to create a profile for users on signup.
thanks in advance.
i am creating a profile table for my users, and tried to add a foreign key relation to the key updated_at as it also exists at auth.users.profiles.
but doing that gives me an error: ERROR: 42830: there is no unique constraint matching given keys for referenced table "users"
what can i do?
i later want to use a trigger to create a profile for users on signup.
thanks in advance.
