AggregateError on valid query

[andreiwow2]

Hello, I have the following example query:

SELECT "sharepointDriveId", "fileSharepointId", "lastChangeDateTimeIso"
FROM "indexedFiles"
WHERE ("sharepointDriveId", "fileSharepointId") IN (('23132131', '4543535'), ('23132131', '232452'), ('23132131', '786745'))

Tested it in DBeaver and it works.

In node-red I set it in the query field to test and I get an AggregateError

I also tried with just SELECT * FROM "indexedFiles";

Same error, "AggregateError".

---

update

Apparently the error was linked to environmental variables

Seems related to this: https://github.com/alexandrainst/node-red-contrib-postgresql/issues/64

[Alkarex]

What about a simpler query such as SELECT 1; ?