<!DOCTYPE html>
<html><head>
<meta charset="UTF-8">
</head><body><p>hi lukas,<br></p><p>please don't alter s.th. in the database.<br></p><p>you have to do an update statement like:<br></p><p><br></p><p>update layer_epsg set minx=6.15, miny=48.70, maxx=9, maxy=98 where fkey_layer_id = 19333 and epsg='EPSG:4326';<br></p><p><br></p><p>beware - if you update the wms - the extent will be overwritten! - store the sql, to set it again after an update if the wms is from an external source. ;-)<br></p><p>armin<br></p><blockquote type="cite"><p>"lukas.bollack" <lukas.bollack@naturnetz.ch> hat am 16. Februar 2016 um 16:17 geschrieben:<br><br><br>This may be a stupid question, but I'm not too familiar with databases:<br><br>I would like to set the bbox directly in the layer_epsg table. Now I can<br>identify the layer via the layer id so I know which row I have to alter. But<br>pgAdmin tells me I can't do anything in the table because the table doesn't<br>have a primary key. Is there a way to alter the table anyway or should I<br>insert a new attribute and use it as primary key? Will I wreck my database<br>with this?<br><br><br><br>--<br>View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapbender-2-7-4-A-couple-of-questions-tp5250589p5250852.html<br>Sent from the mapbender-users mailing list archive at Nabble.com.<br>_______________________________________________<br>Mapbender_users mailing list<br>Mapbender_users@lists.osgeo.org<br>http://lists.osgeo.org/mailman/listinfo/mapbender_users</p></blockquote><p>> http://lists.osgeo.org/mailman/listinfo/mapbender_users</p></body></html>