Hi! I am loving n8n and am working my way through all of the different features. I am having a weird issue with the Postgres node, however. First I wanted to create an entry in a table manually. I kept getting that relation [table] does not exist. I tried the query I had constructed in the node using SQL Workbench, however, and it worked just fine… okay, weird, I figured I was still missing something. So then I just tried a super simple query from my table “cdc_rss”. - Select * from cdc_rss. Again, no dice. I get this:
ERROR: relation "cdc_rss" does not exist error: relation "cdc_rss" does not exist at Connection.parseE (/usr/local/lib/node_modules/n8n/node_modules/pg-promise/node_modules/pg/lib/connection.js:604:11) at Connection.parseMessage (/usr/local/lib/node_modules/n8n/node_modules/pg-promise/node_modules/pg/lib/connection.js:401:19) at Socket.<anonymous> (/usr/local/lib/node_modules/n8n/node_modules/pg-promise/node_modules/pg/lib/connection.js:121:22) at Socket.emit (events.js:210:5) at addChunk (_stream_readable.js:308:12) at readableAddChunk (_stream_readable.js:289:11) at Socket.Readable.push (_stream_readable.js:223:10) at TCP.onStreamRead (internal/stream_base_commons.js:182:23)
I thought maybe I’ve configured the Postgres credentials incorrectly, but I’m using the same exact credentials I have in SQL Workbench. This query “Select * from cdc_rss” also works via SQL Workbench. Am I missing something obvious here? Perhaps n8n doesn’t support the latest version of Postgres?
My postgres instance is on RDS, but should be configured to all all public traffic. It’s working from my personal laptop, so not sure why it wouldn’t work from my n8n domain…