Hello everyone, I have a small database. Django version currently 2.2, postgres 9.2.24. I forgot to note the psycopg2 older version. It was working fine. I have updated django to 2.2.26 and psycopg2==2.8.3. Also, I made changes in my model and migrated. I come across this error during migration.
psycopg2.errors.SyntaxError: syntax error at or near "WITH ORDINALITY" I searched google and found this post https://stackoverflow.com/questions/61774741/psycopg2-errors-syntaxerror-syntax-error-at-or-near-on it suggests to upgrade the postgres version also. My question is 1) If I upgrade the postgres in the server will it affect data (other databases) in the postgres. I don't want to lose other databases. Any suggestions? Thanks Kannan -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CADiZb_d9AdyY%3DcPd6vrffQab6mum0JB5vr1R_A6E1%3DX_oe6fzw%40mail.gmail.com.

