https://prefect.io logo
Title
m

Matt Allen

08/25/2020, 3:34 PM
I'm getting an error when the graphql service tries to run it's Alembic migrations against an RDS postgres instance. Has anyone seen anything like this before?
Error: (psycopg2.errors.SyntaxError) syntax error at or near "REFERENCING"
LINE 61: ...rting_state AFTER INSERT ON public.flow_run_state REFERENCIN...
j

Jenny

08/25/2020, 5:11 PM
Hi @Matt Allen - I've not seen that before but will check with the team.
m

Matt Allen

08/25/2020, 5:11 PM
I think the problem was being on postgres 9 actually, upgrading got us past this error
j

Jenny

08/25/2020, 5:11 PM
Ah great. Thanks for the update!