Cool thanks guys, I haven't had a chance to look at the database structure yet, so hopefully the geometry columns aren't the primary keys.
- Brian F On 01/28/2012 08:48 PM, Steve Singer wrote: > 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
