Something went wrong. Try again.
Rust AppView - highly experimental! forked from parakeet.at/parakeet
Something went wrong. Try again.
1234567891011-- Copy labels from label_tmp staging table to labels table-- Uses DISTINCT ON to ensure unique (labeler_actor_id, label, uri) combinationsINSERT INTO labelsSELECT DISTINCT on (labeler_actor_id, label, uri) *FROM label_tmpON CONFLICT (labeler_actor_id, label, uri) DO UPDATE SET negated=EXCLUDED.negated, expires=EXCLUDED.expires, sig=EXCLUDED.sig, created_at=excluded.created_at