search

timgit / pg-boss

Queueing jobs in Postgres from Node.js like a boss
MIT License
2.15k stars 160 forks source link

Dead letter queue doesn't seem executed? #501

Closed NicolasDorier closed 1 month ago

NicolasDorier commented 1 month ago

I haven't executed this by myself, I plan to make a library in C#, and I was reviewing your code. Except error on my part dlq_jobs isn't referenced anywhere in the query, as such, I highly doubt it is ever executed.

I tried to ask copilot about this, but it doesn't seems to see the problem...

https://github.com/timgit/pg-boss/blob/0f282769daf825123199dfa3a1adbd55168ae423/src/plans.js#L558-L690

NicolasDorier commented 1 month ago

My apoligies, I think I misundertstood CTE...