A limitation of using collections is that you cannot reuse the name used for a collection column with another collection type. Let's try to drop a collection column and recreate it with a different collection type (drop all depending indexes before dropping the column):
DROP INDEX user_social_identities_idx; ALTER TABLE "users" DROP social_identities;
ALTER TABLE "users" ADD social_identities set<text>;
You will get an error: