Can't update by key of type UUID in Postgres node

Questions
1

Describe the issue/error/question

Can’t update by key of type UUID in Postgres node.

I’m using n8n v 0.160.0 & pg v13.3

What is the error message (if any)?

" ERROR: operator does not exist: text = uuid "

Please share the workflow

(Select the nodes and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow respectively)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database you’re using (default: SQLite):
  • Running n8n with the execution process [own(default), main]:
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]:
2

Hey @kyanokashi, welcome to the community :tada:

Could you try the type casting functionality integrated into n8n’s Postgres node and specify the update column like id:uuid instead of id (replace id with your actual column name)? This did the trick for me:

image
image781×713 20.9 KB

My test table had a structure of CREATE TABLE kyanokashi (id uuid DEFAULT uuid_generate_v4(), name VARCHAR);.

If the above doesn’t work for you, could you confirm how your table looks like and share the workflow you are using?

3

Worked thank you so much!!!

2 Likes