Erorr in running create set command

Started by Ashish Karalkarover 19 years ago2 messagesgeneral
Jump to latest
#1Ashish Karalkar
ashish_karalkar@yahoo.com

Hello All,

I am trying to add a new table to an running
replication system.

For that i want to create new set but it is giving me
error.
slonik <<_EOF_

create set (id=2, origin=1, comment='All qsweb

tables');

_EOF_

<stdin>:1: ERROR: syntax error at or near create

can anybody tell me how can i create new set in the
same schema in which it will be merge later on

do i need to create new set in the same schema?
i have tried in creating new schema but then while
merging it give me syntax error as follows

slonik <<_EOF_

MERGE SET ( ID = 2,ADD ID = 1, ORIGIN = 1 );
_EOF_

<stdin>:1: ERROR: syntax error at or near MERGE
thanks & regards
ashish karalkar

____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited

#2Bernd Helmle
mailings@oopsware.de
In reply to: Ashish Karalkar (#1)
Re: Erorr in running create set command

On Thu, 30 Nov 2006 03:23:03 -0800 (PST), Ashish Karalkar <ashish_karalkar@yahoo.com> wrote:

Hello All,

I am trying to add a new table to an running
replication system.

Please stop posting Slony-I related questions to this list.
slony1-general is the more applicable list for this, see my reply there.

Thanks,

Bernd