BruceFletcher / node-red-contrib-postgres-multi

Multi-query variant of node-red-contrib-postgres
Apache License 2.0
5 stars 11 forks source link

Stopped working with Node-RED 1.3.5 #8

Open elmicha opened 3 years ago

elmicha commented 3 years ago

Hi,

I upgraded to Node-RED 1.3.5 a few weeks ago, and node-red-contrib-postgres-multi doesn't work since then. It gives no error messages, it just doesn't write into the database.

inglevir commented 3 years ago

the very same issue

Pranavthakkar commented 3 years ago

same issue. node.js version is 14.17.2 nodered version is 1.3.5

MrLight commented 3 years ago

same here node.js 14.17.3 node-red 2.0.3

inglevir commented 3 years ago

Guys, does someone found decent replacement?

MrLight commented 3 years ago

not yet... for me it looks like code line 127 never returns... const client = await pool.connect(); but I haven't found out why for now...

Short update: The problem is a bug in the underlying pg library.

A npm remove pg npm install pg@latest could help.

I also had to change some code in the node-red-contrib-postgres-multi library, but for now I'm not 100% sure if this was needed...