"Levasseur, Fabrice" <fabrice.levasseur at eds.com> writes:
> Hi,
>
> Slony add a specific column with a "slony primary key" inside all tables.
> So you don't need to update your database.
>
> Exemple:
>   ident   |   nom   | latitude | longitude | _Slony-I_test1_rowID
> ----------+---------+----------+-----------+----------------------
>  00000000 | POINT00 |          |           |     1000000000021188
>  00000001 | POINT01 |          |           |     1000000000021189
>  00000002 | POINT02 |          |           |     1000000000021190
>  00000003 | POINT03 |          |           |     1000000000021191
>  00000004 | POINT04 |          |           |     1000000000021192
>  00000005 | POINT05 |          |           |     1000000000021193

Supposing there are many millions of rows in that table, adding and
populating the _Slony-I_test1_rowID slot as well as the index will
take a painful amount of time during which other updates can't take
place.  Possibly a bad thing???
-- 
output = reverse("ofni.sailifa.ac" "@" "enworbbc")
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)