bug: three column unique index no change never detected

ex:

  uniqueReactPerPost: unique('post_id_reaction_user_id').on(
      postId,
      reaction,
      reactorId,
    ),

  uniqueReactPerPost: unique('post_id_reaction_user_id').on(
      postId,
      reaction,
      reactorId,
    ),

  uniqueReactPerPost: unique('post_id_reaction_user_id').on(
      postId,
      reaction,
      reactorId,
    ),

  uniqueReactPerPost: unique('post_id_reaction_user_id').on(
      postId,
      reaction,
      reactorId,
    ),

the above index will be ran, but if you run it again, it'll prompt you to truncate the table, and if you chose not to, it'll run sucessfully but will drop -> then recreates.

orm latest,
pg 15

bug: three column unique index no change never detected

Similar Threads

Similar Threads

Similar Threads