Slony Issue Fix in pgAdmin

From: Neel Patel <neel(dot)patel(at)enterprisedb(dot)com>
To: Dave Page <dave(dot)page(at)enterprisedb(dot)com>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Slony Issue Fix in pgAdmin
Date: 2013-09-24 11:24:28
Message-ID: CAMcbDBH5WuVK2S-DohBxZPV7uSa6bk+7khXeg3OKoBz-w1Dqrw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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

Attachment Content-Type Size
Slony_Fix.patch application/octet-stream 3.3 KB

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dinesh Kumar 2013-09-24 11:37:11 Patch for Race Condition.
Previous Message Dhiraj Chawla 2013-09-24 09:39:00 Re: Event Triggers are not listed in the browser view options on the Settings dialogue