On Thu, Dec 28, 2023 at 4:42 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:
On Thu, Dec 28, 2023 at 2:38 PM Matheus de Oliveira <matioli.matheus@xxxxxxxxx> wrote:[snip]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.
Best regards,
-- Matheus de Oliveira
