db-postgres: after reordering array rows, a row without a polymorphic relationship inherits the one stored in _rels at its new index
Maintainers usually reply within 1 day
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 55/100
- Issue type
- Bug
- Clarity
- Clearly specified
- Activity status
- Active
- Tech stack
- postgresql, typescript
- Domain
- database
Research direction
The issue identifies @payloadcms/drizzle's upsertRow as the affected entry point. Read how it updates positional paths in the Postgres _rels table, then reproduce the reorder with repro-5.ts against an empty PostgreSQL database. It is done when the saved _rels rows contain only relationships present in the data and Login has no inherited reference.
Written by the indexing model from the issue text.
Description
Describe the Bug
In the Postgres adapter, relationships inside arrays are stored in <table>_rels under positional paths (links.0.reference, links.1.reference). On update, upsertRow deletes the existing rels only for the paths it re-inserts. A row whose relationship is absent from the data never clears the rel at its index. In the reproduction, that is a polymorphic relationTo: ['notes'] field shown only for type: 'internal'. After a reorder, such a row inherits the relationship of the row that used to be at its position.
A single-collection relationTo: 'notes' is stored as a column on the array table, so it is not affected. Only relationships that go through _rels are affected: polymorphic ones, and presumably hasMany ones.
Expected: after the update, _rels holds only the relationships present in the saved data, and the moved row's reference is empty.
Link to the code that reproduces this issue
https://github.com/elghaied/payload-v4-reproductions (repro-5.ts)
Reproduction Steps
pnpm install, thencp .env.example .envand pointDATABASE_URLat an empty PostgreSQL databasepnpm repro repro-5.ts
The script creates a menu with [First (internal, reference → a note), Login (external, no reference)], then saves [Login, First] with the same ids, First keeping its reference. Output:
menus_rels rows: [{"path":"links.0.reference","notes_id":3},{"path":"links.1.reference","notes_id":3}]
observed Login.reference: { relationTo: 'notes', value: 3 } expected: null/undefined
Which area(s) are affected?
db-postgres (@payloadcms/drizzle upsertRow)
Environment Info
payload: 4.0.0-beta.9
@payloadcms/db-postgres: 4.0.0-beta.9
Node.js: 24.22.1
PostgreSQL: 17.10
(local API only, no Next.js app)
- Dominant language
- TypeScript
- Stars
- 45.8k
- Forks
- 4.4k
- Avg merge
- 2d 16h
- Merged PRs (30d)
- 251
Getting set up
Starts the project's dev container in your browser, under your own GitHub account.
- No Dockerfile or Docker Compose file
- Has a pull request template
- Read the contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from payloadcms/payload
-
db-d1-sqlite: upsert is aliased to updateOne, so payload.kv.set never inserts new keysPossibly taken @pcbeingused333 claimed this today. OpenBug db: d1-sqlite Payload OSS
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
payloadcms/payload#19766 ·
Maintainers usually reply within 1 day
-
Document bar (.doc-controls__content) overflows a 375 px viewport, clips "Created" and fails axe scrollable-region-focusablePossibly taken A pull request linked to this issue is open or already merged. Openarea: ui Bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
payloadcms/payload#19690 ·
Maintainers usually reply within 1 day
-
[v4] Blocks thumbnails croped 3:2Possibly taken @samiarif02 claimed this 2 days ago. Openarea: ui Bug Payload OSS status: needs-triage v3
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
payloadcms/payload#19609 ·
Maintainers usually reply within 1 day
-
Scheduled publish jobs are not deleted when their document is deleted (string id in the job, raw id in the cleanup)Possibly taken @volodymyrshk claimed this 10 days ago. Openarea: core Bug db: sqlite
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
payloadcms/payload#19448 ·
Maintainers usually reply within 1 day
-
plugin-multi-tenant: `isGlobal` collections redirect tenant-scoped users to `/admin` since 3.93.0 (GlobalViewRedirect prop-name mismatch)Possibly taken @JarrodMFlesch claimed this 10 days ago. OpenBug plugin: multi-tenant
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
payloadcms/payload#19420 · 1 assignee ·
Maintainers usually reply within 1 day
All issues in payloadcms/payload
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
milind-soni/OpenMausBot#6730 ·
Maintainers usually reply within 1 day
-
`@angular/[email protected]` depends on vulnerable Vite 7.3.7 - GHSA-p4f5-76q4-ffq7 (Critical RCE)Openarea: @angular/build
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
angular/angular-cli#34764 ·
Maintainers usually reply within 1 day
-
status/need-triage
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
google-gemini/gemini-cli#30384 · 1 comment ·
Maintainers usually reply within 1 day
-
P2
Difficulty 1/5 Under an hour Newbie friendliness 84/100
Maintainers usually reply within 1 day
-
area:image documentation good first issue
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
Maintainers usually reply within 1 day