Re: [Slony1-general] 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/