Newly subscribed federated communities have incorrect post_aggregates.published and newest_comment_time from outbox

[dessalines]

https://lemmy.ml/post/51497

On a subscribe to a federated community, it fetches the outbox. That outbox correctly sets the post.published, but our actual post sorting uses post_aggregates.published and post_aggregates.newest_comment_time, both of which have default inserts of now().

The best way might be to alter this table trigger, to make sure it doesn't use those defaults:

create function post_aggregates_post()
returns trigger language plpgsql
as $$
begin
  IF (TG_OP = 'INSERT') THEN
    insert into post_aggregates (post_id) values (NEW.id);
  ELSIF (TG_OP = 'DELETE') THEN
    delete from post_aggregates where post_id = OLD.id;
  END IF;
  return null;
end $$;

But that is contingent on the original post insert in the federated code using correct values, and not setting them after the fact.