[postgis-users] Releasing a lock on a view/database

Chris Stromberg chris.stromberg at cambridgeshire.gov.uk
Thu Mar 1 02:05:52 PST 2012

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? 


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.

More information about the postgis-users mailing list