PS: As said in the other thread, a primary key on (granule_uuid, file_id) would make more sense, but you need to get rid of null values on these rows before creating the PK.
Can't you create a unique index index on fields with nulls?
Yes, you can create an unique index on fileds with nulls. But not a primary key, a primary key requires that all fiedls are NOT NULL.
