SELECT "taxonNameOrEpithet" FROM family_homonyms GROUP BY "taxonNameOrEpithet" HAVING NOT util.all_same(kingdom) -- not internal Plantae homonyms ; ALTER TABLE :table ADD PRIMARY KEY ("taxonNameOrEpithet");