Postgres routine editor shows outdated version

When I modify a plpython routine in a Postgres SQL 9.6 database, the function appears under the "routines" node in the Database window, but its types (variables and return, both as shown in the summary under the "routines" node) and its code when opened with  "Routine editor" are not the latest.

However, if opened with "Open DDL in console", the code is correct.

PyCharm 2016.3.3
Build #PY-163.15188.4, built on March 10, 2017
JRE: 1.8.0_112-release-408-b6 amd64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o

 

0
3 comments

Hi,

Do you have Auto-sync enabled for your data source?
Could you provide any screenshot of your routine editor with incorrect source code?

Try to invoke Forget Cashed Schemas for your data source and Synchronize your data source again.



Thank you.

0
Avatar
Permanently deleted user

I have the same problem as describe above and have lost multiple iterations of work because of it. I have auto sync enabled for my datasource and this still occurs. 

0

Hi,

How do you submit your changes to a database?
Thank you.

0

Please sign in to leave a comment.