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 greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20140226/c4905268/attachment.pgp