[Nest] 32  - 09/24/2025, 8:53:11 PM   ERROR [Api:AssetMediaService~pj44aovo] Error uploading file PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification

PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification

    at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)

    at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)

    at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)

    at Socket.emit (node:events:518:28)

    at addChunk (node:internal/streams/readable:561:12)

    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)

    at Readable.push (node:internal/streams/readable:392:5)

    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)

    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)

[Nest] 32  - 09/24/2025, 8:53:11 PM   ERROR [Api:ErrorInterceptor~pj44aovo] Unknown error: PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification

PostgresError: there is no unique or exclusion constraint matching the ON CONFLICT specification

    at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)

    at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)

    at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)

    at Socket.emit (node:events:518:28)

    at addChunk (node:internal/streams/readable:561:12)

    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)

    at Readable.push (node:internal/streams/readable:392:5)

    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)

    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)