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]:
Hey @kyanokashi, welcome to the community
Could you try the type casting functionality integrated into n8n’s Postgres node and specify the update column like
id:uuid instead of
id with your actual column name)? This did the trick for me:
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?
Worked thank you so much!!!