From: | Ashish Karalkar <ashish_karalkar(at)yahoo(dot)com> |
---|---|
To: | slony <pgsql-general(at)postgresql(dot)org>, slony <slony1-general(at)gborg(dot)postgresql(dot)org> |
Subject: | Erorr in running create set command |
Date: | 2006-11-30 11:23:03 |
Message-ID: | 852162.35166.qm@web31607.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2006-11-30 11:33:50 | Re: postgresql 8.2 rc1 - crash |
Previous Message | Michael Glaesemann | 2006-11-30 11:21:12 | Re: Float8 precision problem |