I'm trying to edit a view that is not currently in active use, but has been used previously.
when submitting the change to the view, the SQL window just says 'query is running' and it'll sit there until i stop it. If i restart the postgres service, obviousely, all locks are released, so when i run the update view statement, it works immediately. But this is not practical when other tables/views are in use. Any one know how i can amend a view when the rest of the database is in use? thanks -- View this message in context: http://postgis.17.n6.nabble.com/Releasing-a-lock-on-a-view-database-tp4534379p4534379.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
