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