On Wed, Feb 26, 2014 at 11:39:20AM -0700, CS DBA wrote: > We have a client running postGIS, we're preparing to deploy SLONY. > However the postGIS meta tables geometry_columns and spatial_ref_sys do > not seem to get deployed with primary keys (via the postGIS install & > enabling a db to be spatial).
In recent versions of PostGIS, geometry_columns is a view, so you do not need to worry about that. The spatial_ref_sys table should already have a primary key on srid. What version of PostGIS are you using? If an older one, then yes, your best option is to add primary keys: make srid a primary key for spatial_ref_sys, and the the geometry_columns table will need one spanning the catalog, schema, table, and 'column' columns. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
