Please help... syntax Error in create set ..

Hi,

On Thu, 2006-11-30 at 00:12 -0800, Ashish Karalkar wrote:

create set (id=2, origin=1, comment='All tables');

but it gives error

syntax error near unexpected token `('

That command must be passed to slonik, not to bash.

Here is an example:

#!/bin/bash
slonik << _END_

cluster name = testcluster;
node 1 admin conninfo = 'dbname=test1 host=192.168.2.3 port=5432
user=postgres';
node 2 admin conninfo = 'dbname=test2 host=192.168.2.4 port=5432
user=postgres';

create set (id=1, origin=1, comment='test tables');
echo 'Set created';

set add table (set id=1, origin=1, id=1, full qualified name =
'public.test_table', comment='test table');
_END_

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

Thanks for your repaly

I have done with that but facing the same problem.
Actually what i want to do is to add a table to a
already existing replication set.

firstly, I will have to create new set
secondly subscrib it .
and finaly merge it.

do i need to create this set in the same cluster into
which i will merge it later on.
If yes, how to do it coz with the slonik script it
gives me error cluster already exists.

Please help.
Thanks

--- Devrim GUNDUZ <devrim@CommandPrompt.com> wrote:

Hi,

On Thu, 2006-11-30 at 00:12 -0800, Ashish Karalkar
wrote:

create set (id=2, origin=1, comment='All tables');

but it gives error

syntax error near unexpected token `('

That command must be passed to slonik, not to bash.

Here is an example:

#!/bin/bash
slonik << _END_

cluster name = testcluster;
node 1 admin conninfo = 'dbname=test1
host=192.168.2.3 port=5432
user=postgres';
node 2 admin conninfo = 'dbname=test2
host=192.168.2.4 port=5432
user=postgres';

create set (id=1, origin=1, comment='test tables');
echo 'Set created';

set add table (set id=1, origin=1, id=1, full
qualified name =
'public.test_table', comment='test table');
_END_

Regards,
--
The PostgreSQL Company - Command Prompt, Inc.
1.503.667.4564
PostgreSQL Replication, Consulting, Custom
Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG -
http://www.commandprompt.com/

____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com