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 django-users+unsubscr...@googlegroups.com. 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.
