You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When trying to delete or replace a category from a product using the product edit modal in the Medusa admin interface, the operation fails. The backend throws an error indicating that it cannot delete from the product_category_product table because it lacks a replica identity, even though it's configured to publish deletes. This issue prevents the successful updating of product categories through the UI, leading to data inconsistency and a degraded user experience.
error: cannot delete from table "product_category_product" because it does not have a replica identity and publishes deletes
Expected behavior
The expected behavior is that when a category is deleted or replaced from a product in the edit modal, the changes should be reflected in the database without any errors. The product_category_product table should update accordingly to reflect the new product-category relationships.
Additional context
This issue may be related to the PostgreSQL configuration for the product_category_product table, particularly its replication settings and the lack of a defined replica identity. This table is likely involved in logical replication, and the inability to perform delete operations due to the missing replica identity complicates data management tasks through the Medusa admin interface.
The text was updated successfully, but these errors were encountered:
Bug report
Describe the bug
When trying to delete or replace a category from a product using the product edit modal in the Medusa admin interface, the operation fails. The backend throws an error indicating that it cannot delete from the product_category_product table because it lacks a replica identity, even though it's configured to publish deletes. This issue prevents the successful updating of product categories through the UI, leading to data inconsistency and a degraded user experience.
System information
Medusa version (including plugins): 1.20
Node.js version: 18.17.1
Database: postgres (PostgreSQL) 14.9
Operating system: MacOS
Browser (if relevant): Chrome
Steps to reproduce the behavior
Console:
Expected behavior
The expected behavior is that when a category is deleted or replaced from a product in the edit modal, the changes should be reflected in the database without any errors. The product_category_product table should update accordingly to reflect the new product-category relationships.
Additional context
This issue may be related to the PostgreSQL configuration for the product_category_product table, particularly its replication settings and the lack of a defined replica identity. This table is likely involved in logical replication, and the inability to perform delete operations due to the missing replica identity complicates data management tasks through the Medusa admin interface.
The text was updated successfully, but these errors were encountered: