Hi Dave,
Please find the attached patch file for fix of below slony issue in pgAdmin.
Steps to reproduce:-
- Install PostgreSQL 9.3 and Slony version 2.2.0.
- Open pgAdmin
- Create new Schema and give cluster name in "Use Slony" option.
- Click OK and below error will come.
##################################################################
ERROR: function _edb_cluster.ddlscript_prepare(integer, integer) does not exist
LINE 1: SELECT _edb_cluster.ddlscript_prepare(1, -1);
##################################################################
Solution:-
As we are using ddlscript_prepare() statement to replicate the new schema to slave and from new Slony version 2.2.0 this function no more supported and removed so as per the document we have to use ddlcapture() method instead of ddlscript_prepare(). Also ddlscript_complete() method arguments got changed so that also fixed.
Please review it and let me know for any modifications.
Thanks,
Neel Patel