On 3/1/2012 4:05 AM, Chris Stromberg wrote:
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
Sounds like you have transactions left open, which can keep things
locked. check ps ax|grep postgres for things that say "idle in transaction"
Also, you can query pg_locks and it can tell you what is using it.
Also, check pg_stat_activity so see what's currently running.
-Andy
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
