RoundSparrow @ BTM to Lemmy Project Priorities Observations • 1 year ago2023-08-06message-square7arrow-up12arrow-down10
arrow-up12arrow-down1message-square2023-08-06RoundSparrow @ BTM to Lemmy Project Priorities Observations • 1 year agomessage-square7
minus-squareRoundSparrowlinkfedilink1•1 year agoUPDATE “comment” SET “path” = $1 WHERE (“comment”.“id” = $2) RETURNING “comment”.“id”, “comment”.“creator_id”, “comment”.“post_id”, “comment”.“content”, “comment”.“removed”, “comment”.“published”, “comment”.“updated”, “comment”.“deleted”, “comment”.“ap_id”, “comment”.“local”, “comment”.“path”, “comment”.“distinguished”, “comment”.“language_id”
minus-squareRoundSparrow @ BTOPMlinkfedilink1•1 year agoWait…, so after an INSERT you have two of these UPDATES to set the id of the comment? UPDATE “comment” SET “ap_id” = $1 WHERE (“comment”.“id” = $2) RETURNING “comment”.“id”, “comment”.“creator_id”, “comment”.“post_id”, “comment”.“content”, “comment”.“removed”, “comment”.“published”, “comment”.“updated”, “comment”.“deleted”, “comment”.“ap_id”, “comment”.“local”, “comment”.“path”, “comment”.“distinguished”, “comment”.“language_id”
UPDATE “comment” SET “path” = $1 WHERE (“comment”.“id” = $2) RETURNING “comment”.“id”, “comment”.“creator_id”, “comment”.“post_id”, “comment”.“content”, “comment”.“removed”, “comment”.“published”, “comment”.“updated”, “comment”.“deleted”, “comment”.“ap_id”, “comment”.“local”, “comment”.“path”, “comment”.“distinguished”, “comment”.“language_id”
Wait…, so after an INSERT you have two of these UPDATES to set the id of the comment?
UPDATE “comment” SET “ap_id” = $1 WHERE (“comment”.“id” = $2) RETURNING “comment”.“id”, “comment”.“creator_id”, “comment”.“post_id”, “comment”.“content”, “comment”.“removed”, “comment”.“published”, “comment”.“updated”, “comment”.“deleted”, “comment”.“ap_id”, “comment”.“local”, “comment”.“path”, “comment”.“distinguished”, “comment”.“language_id”