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

I want to create new set,
I am running create set command as follows


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

but it gives error

 syntax error near unexpected token `('

can anybody tell me where i am doing wrong


With regards
Ashish



____________________________________________________________________________________
Cheap talk?
Check out Yahoo! Messenger's low PC-to-Phone call rates.
http://voice.yahoo.com

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