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
