-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,


Sweta Mulgavker a écrit :
(...)

>  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

Be careful, you have to qualify the sequence with its schema, i.e. if the
sequence is in the public schema, you have to write sthg like

select "_replcluster".setAddSequence(8, 57, 'public.t_history_serial_seq',
't_history_serial_seq  sequence');

Notice the *public.* in sequence name.
(...)

> 
> So my questions is.....
> 
>  1)Do I have to add these sequences in the config file...
>     I mean using  "set add sequence "?

Yes, you have to.

> 
> Or will they get replicated without mentioning about them in the config
> file???

No, they won't.


Regards,
- --
Stéphane Schildknecht
PostgreSQLFr - http://www.postgresql.fr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFKfUPIA+REPKWGI0ERApZKAJ46oqUJXO2iX61wIwuTgcFfo0US0wCeLMoo
SIR6mqhq2qWNCG1i8t86m38=
=xvH3
-----END PGP SIGNATURE-----