Sat Aug 8 00:46:30 PDT 2009
- Previous message: [Slony1-general] Sequences not getting added
- Next message: [Slony1-general] Sequences not getting added
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Sat, Aug 8, 2009 at 4:32 PM, Sweta Mulgavker <sweta.mulgavker at gmail.com>wrote: > Hello All, > > Here is another problem with my replication system .... (I have already h= ad > 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/ -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090808/= 90438b96/attachment.htm
- Previous message: [Slony1-general] Sequences not getting added
- Next message: [Slony1-general] Sequences not getting added
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list