alexandrainst / alexandrainst/node-red-contrib-postgresql
AggregateError on valid query
Nobody has claimed this yet.
- Dominant language
- HTML
- Stars
- 38
- Forks
- 12
- Avg merge
- 4h 1m
- Merged PRs (30d)
- 2
Description
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
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the AggregateError in the Node-RED query field using both the reported tuple query and SELECT * FROM "indexedFiles". Start by checking the PostgreSQL environmental variables and compare the behavior with the related issue #64. Done means identifying whether configuration causes the error and documenting or fixing the resulting failure path.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- node.js, postgresql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100