I would like to submit a patch for the Procedure "RENAME, SET SCHEMA" issue.
Issue: ====
If we try to rename the Procedure from the pgAdmin 1.16 by it's properties dialogue window, then we will get "ERROR: syntax error at or near RENAME".
Attached the screen shot of this issue, and the bug fix.
Thanks in advance.
Have you tested this with older versions of PPAS (i.e. 8.4)? If memory serves, the were inconsistencies in the way procedure modifications we made in older versions.
I have tested the same case against PPAS 8.4 with pgAdmin 1.16 and got the same error. And i have my old setup, which is PPAS 8.3R2 and PEM (2.0.2) and it is working fine.
Also, is changing of the owner not supported? The patch seems to remove code to deal with that.
Sorry Dave, It's my mistake. I have double checked the ownership changes of procedure and included the respective call function in place.