Hi all! I am getting an error in a new postgres node when using “insert or update” operation (see screenshot). Error content: Issues: There was a problem loading the parameter options from server: "Connection pool of the database object has been destroyed." . What could this be related to, occur…

Perfect and what about using execute query? There isn’t going to be a quick fix for this today, have you also tried the supabase node?

In test mode, I run the same query and get different results (screencast 1). In manual mode, I get the result, but with incomprehensible execution work (large delay, perhaps this is a completely different problem) (screencast 2). I haven’t tested with the Supabase node yet. screencast 1 [2023-0…

What about with the execute query operation?

Do you mean make the same task a SQL query?

Yeah so in the node rather than using the insert / update select Execute Query and manually input the query and see if that works. It could also be worth copying the node out and putting it into a text editor and changing the typeVersion value to 1 then copy / paste back into n8n and see if that wor…

Hey @Jon , I ran all the tests, the results are in the screenshot. [n8n - - Google Chrome 2023-05-13 19.53.41]

Hey @Roket , We already know about the v2 node so no need to test the upsert again :slightly_smiling_face: The execute query operation will be the best solution for now.

Hey @Roket , We have just put in a fix that should solve this here: fix(Postgres Node): Remove reusable connections (no-changelog) by michael-radency · Pull Request #6259 · n8n-io/n8n · GitHub it should be available either this week or next week depending on how long the review takes.

New version n8n@0.230.1 got released which includes the GitHub PR 6259 .

I am getting an error in a new postgres node when using "insert or update" operation

Questions

Roket May 13, 2023, 1:59pm 25

Hey @Jon,
I ran all the tests, the results are in the screenshot.

POSTGRES ERROR: Connection pool of the database object has been destroyed

Topic		Replies	Views
Serious error in postgres node Questions postgres	14	1904	September 6, 2023
POSTGRES ERROR: Connection pool of the database object has been destroyed Questions postgres	29	2534	September 6, 2023
Postgres Node - errors inserting data using Execute Query as well as using upsert Questions data-transformation , postgres	14	5107	July 12, 2023
Found a bug with postgres. Previously, "Insert or Update" worked, but now it doesn't Questions node , docker-compose , postgres	8	332	July 10, 2025
Error using Postgres Chat Memory and Supabase for AI Tools Agent Questions node , workflow-building	34	2208	May 21, 2025

I am getting an error in a new postgres node when using "insert or update" operation

Related topics