On Sat, 28 Jan 2012, Christopher Browne wrote:
As long as the data types serialize in a reasonable form, and survive pg_dump, they should replicate fine. Needs to be stable to use it in a primary key. E.g. , date stamp values may reload as a slightly different value due to rounding. If GIS values do the same, they may make poor primary keys. Slony might expose edges you mightn't see elsewhere.
I sometimes setup replication clusters of GIS data when testing slony and have never had a problems, I can't even recall any edge cases that it exposed.
Making a postgis geometry column part of a primary key is a bad idea/design even if you aren't using slony.
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
