Duplicate data storing in PostgreSQL

Questions and Answers Database-SQL
1
System Information
  • Strapi Version: 5.1.0
  • Operating System: MacOS Monterey
  • Database: PostgreSQL 14.0
  • Node Version: 20.14.0
  • NPM Version: 10.7.0
  • Yarn Version:

I have a problem with data storing in my PgAdmin. My published data is stored as two duplicate records, one with published_at “null” and one with published_at “timestamp”. Technically, it should be only one record, if it’s a draft entity it should be null for the published_at attribute and updated to be timestamp value when it’s published. Is there any solution?

2

Hey did you find a solution for this? I keep getting the same problem. Projects I build with Strapi and Postgres will have a duplicate entry one with published_at “null” and one with published_at “timestamp”.

The api request to the collection endpoint returns no duplicates so it’s correct. But not in the database!! :frowning:

3

I haven’t found the solution yet. It may be the new updates from Strapi.