pg is outdated

[johanneskares]

Node Postgres version is quite outdated form more than 2 years ago:

serverless/package.json

Line 94 in 6bf306b

"pg": "8.8.0",

[jawj]

That's true, and it's been on my hypothetical TODO list for a while to update. But it's not trivial, because we shim quite a few internals in a way that I know will need to change.

Are there any particular features or fixes you need that the latest version has?

[andyjy]

I just came to request bump to the latest pg release v8.13.2 from today which includes fix for brianc/node-postgres#3373 ("Cannot set property message of #<_ErrorEvent> which has only a getter" on connection timeout).

Didn't realise it would be more of a major change to update but understand the situation. I'm currently applying this to the bundled pg via a patch so purely noting here in case it helps anyone else - I'm not blocked.

[johanneskares]

Currently, with this old version, timestamps are returned as strings while date's are returned as JS Dates. I believe this default behavior was changed in a more recent version of pg and tools like kysely typegen expect both to be returned as Dates.