April 2017
Beginner to intermediate
360 pages
9h 35m
English
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:

Read now
Unlock full access