Sat Aug 8 01:10:15 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 5:55 PM, Sweta Mulgavker <sweta.mulgavker at gmail.com>wrote: > >> Make sure the sequence does exist in the database... >> > > Yes the sequences are there in the db... > >> >> >> Do something like: >> >> select currval(t_history_serial_seq); >> > > Dint get you ... > >> This function gives the current value for the sequence so I just wanted to make sure if it did exist! Read the manual for more details... If you got tables with serial datatype (which creates an implicit sequence) then you might not need to add sequences explicitly in Slony cluster as that automatically will get updated... when Slony master sends the updates to Slave nodes. -- = Shoaib Mir http://shoaibmir.wordpress.com/ -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090808/= 64d2044c/attachment-0001.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