fix query order to maintain constraints

Pelmenner / TransferBot

Tool for continuous message transfer between chats and messengers using bots

1 stars 2 forks source link

fix query order to maintain constraints #54

Closed Mad-Proger closed 1 year ago

Mad-Proger commented 1 year ago

2023/03/27 20:52:19 ERROR: update or delete on table "messages" violates foreign key constraint "attachments_parent_message_fkey" on table "attachments" (SQLSTATE 23503)

error happened because foreign key dependent row was removed before foreign key was set to NULL