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

Hi,

Sweta Mulgavker a écrit :
> Hello all,
> 
> I am using slony1 1.2.16-1 on CentOS 5 and my postgres version is 8.1.11 .
> 
> Few tables in my database do not have a PRIMARY KEY.
> 
(...)
> If not then is there any other way???   (I cannot change the db structure ).

Maybe you could use surrogate key ? By adding an new column, designed as a
serial, which would be automatically incremented?

That does imply that all of your queries are correctly written, and that you
don't have duplicate rows in tables without primary key.

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

iD8DBQFKeVAVA+REPKWGI0ERAkI9AJ9m/p8KHDOv482pO168q1cTMe6RHgCg08vq
ZzxEYn3EklE6Gj9DwpS1lkI=
=P4XX
-----END PGP SIGNATURE-----