PostgreSQL Discussion - Erorr in running create set command

Author

Erorr in running create set command

Ashish Karalkar

2006-11-30, 7:17 pm

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Bernd Helmle

2006-11-30, 7:17 pm

On Thu, 30 Nov 2006 03:23:03 -0800 (PST), Ashish Karalkar < ashish_karalkar@yaho
o.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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Sponsored Links