Database migration from Mongo to Postgres throwing type error in existing files.

[robinnicholasraja]

Describe the Bug

I'm working on a multi-tenancy project by following this example here.
and it works fine.

Then later I shifted the database from Mongo to Postgres and got a lot of type errors and bugs. I think it will be better to have a proper type check even if we switch the database

Sample screenshots:

Throwing type error while getting the TenantAccessIDs (Unable to login as tenant-admin)

Throws undefined in the getTenantAccessIDs function

Select tenant dropdown value is not updating properly.

Link to the code that reproduces this issue

https://github.com/payloadcms/payload/tree/main/examples/multi-tenant

Reproduction Steps

Follow the readme from this example - https://github.com/payloadcms/payload/tree/main/examples/multi-tenant

Try switching the database from MongoDB to Postgres

Note: I even got some errors in seeding. Then this is what I did, remove ensureUniqueUsername from this path(examples/multi-tenant/src/collections/Users/index.ts) then delete the multi-admin creation from seed.ts then migrate:create followed by migrate:fresh

Which area(s) are affected? (Select all that apply)

db-postgres

Environment Info

payload:
    specifier: latest
    version: 3.1.1(graphql@16.9.0)(monaco-editor@0.52.0)(react-dom@19.0.0-rc-65a56d0e-20241020)(react@19.0.0-rc-65a56d0e-20241020)(typescript@5.6.3),

next: 15.0.0,

pnpm: 9.14.2

[github-actions]

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

[github-actions]

🚀 This is included in version v3.2.2