On Sat, Aug 8, 2009 at 4:32 PM, Sweta Mulgavker <[email protected]>wrote:
> Hello All, > > Here is another problem with my replication system .... (I have already had > plenty of them :'( ) > > I have arround 38 tables and 17 sequences which i am trying to replicate. > The tables addition was smooth but the sequences are not getting added. >:P > > I am getting the following error .... > > PGRES_FATAL_ERROR select "_replcluster".setAddSequence(8, 57, > 't_history_serial_seq', 't_history_serial_seq sequence'); - ERROR: > Slony-I: setAddSequence_int(): sequence t_history_serial_seq not found > CONTEXT: SQL statement "SELECT "_replcluster".setAddSequence_int( $1 , > $2 , $3 , $4 )" > PL/pgSQL function "setaddsequence" line 36 at perform > > Make sure the sequence does exist in the database... Do something like: select currval(t_history_serial_seq); Is the sequence in schema other then public? -- Shoaib Mir http://shoaibmir.wordpress.com/
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
