Describe the problem/error/question
Hello, it’s my first post here. I have a workflow that triggers on a new row inserted in my database. The issue is that Postgres Trigger can’t acces the schema of it, even though the normal node can do queries on n8n.
What is the error message (if any)?
permission denied for schema public
Please share your workflow
Share the output returned by the last node
There is no output as the workflow cant be triggered
Information on your n8n setup
- n8n version: 1.115.3 (Self Hosted)
- Database (default: SQLite): Postgres
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
- Operating system: Mac sonoma 14.6
