Open riverar opened 6 months ago
Hey @riverar,
Thanks for the report, I have created NODE-1245
as our internal ticket to get this fixed.
Hi All,
I'm facing the same issue where my n8n abruptly terminated and upon restarting, it's repeating the error "NodeOperationError: Invalid time value at parsePostgresError". Is there anything I can do to resolve this problem?
Node type n8n-nodes-base.postgres
Node version 2.3 (Latest)
n8n version 1.35.0 (Self Hosted)
Summary
n8n fails to return results from a table with a
timestamp with timezone
column and a row containing-infinity
in this column. These are valid PostgreSQL date/time values, per the docs:Error details
To Reproduce
Create a table with
timestamp with timezone
column and insert test data.Create n8n PostgreSQL node that simply
SELECT * FROM test
Observe error above
Expected behavior
Values to return successfully.
Operating System
Ubuntu 23.10
n8n Version
1.33.1
Node.js Version
18.13.0
Database
SQLite (default)
Execution mode
main (default)