n8n errors / Schema
function gen_random_uuid() does not exist
Cause
A migration calls gen_random_uuid(), which requires the pgcrypto extension, but that extension is absent on the Postgres database.
Fix
Connect as a superuser and run: CREATE EXTENSION IF NOT EXISTS pgcrypto; then restart n8n so the migration completes. For Kubernetes, add this to the postgres init script so it runs automatically on new clusters.
Part of the Automation Error Index — n8n errors: browse all.
Hitting an automation error we have not covered?
AutomateLab builds and debugs n8n, Make, and agent workflows as fixed-scope projects. If something is broken in production, tell us what you are seeing.
Describe the problem