Postgres adapter apply only one unique constraints when there are more than one tables with the same unique fields.

[xiaohanyu]

Link to reproduction

https://github.com/xiaohanyu/test-payload

Describe the Bug

Postgres only respect one unique constraints when more than one collections with the same unique fields.

To Reproduce

Steps to reproduce the bug:

• Init a new payload app by npx create-payload-app@latest, as of now, the latest payload app is 2.5.0
• Create two new collections, Resumes and Templates and add these two new collections to payload.config.ts
• Start payload app by npm run dev

Check postgres table,

You can see that resumes table has "title_idx" UNIQUE, btree (title) where templates do not have this unique index, however, the title field in both Resumes and Templates collection are the same:

    {
      name: "title",
      label: "Title",
      type: "text",
      required: true,
      unique: true,
      minLength: 2,
      maxLength: 64,
    }

Payload Version

^2.0.0

Adapters and Plugins

db-postgres, bundler-webpack

[DanRibbens]

Hi @xiaohanyu!

This was fixed in https://github.com/payloadcms/payload/releases/tag/v2.10.0 via #4967

Let us know if you have any issues.

[github-actions]

This issue has been automatically locked.
Please open a new issue if this issue persists with any additional detail.