On 14 Oct 2013 18:21, "Neel Patel" <neel.patel@enterprisedb.com> wrote: > > Hi, > > As per the slony documentation and code "storenode" API requires below two arguments. > > storenode(p_no_comment integer, p_no_id text)
Have you cross checked with older version of Slony1?
Yes Ashesh you are right. I have checked till slony version 2.0 but now I have checked older version also 1.1 & 1.2, in that "storenode" requires three arguments.
So I will fix this along with slony 2.2.0 support issue that i am currently working on and send the updated patch.
> > > As per the pgAdmin code we are executing below SQL which is wrong. > > SELECT "_<cluster_name>".storeNode(99, 'AdminNode', false); > > > Following are the steps ( PostgreSQL 9.2 ): > > 1. Go to any database and right click "New Slony I cluster ..." > > 2. In the dialog give following inputs. > > Join existing cluster --- Uncheck > Cluster name ---- MyCluster > Local node ---- 1 , MasterNode > Admin node --- 99, AdminNode > Comment ---- TestComment > > 3. Click "OK" button. > > 4. Error will come saying "function _MyCluster.storenode(integer, unknown, boolean) does not exists". > > We need only two arguments to "storenode()" function. > > Why we are passing three arguments to the storeNode() API ? Any Specific reason ? > > Thanks, > Neel Patel > > > > > > > > > Is there any specific reason to