Re: [pgadmin-support] pgadmin freezes on expanding public schema after deleting VIEW

2011-06-17 Thread LPlateAndy
Just to add to this Does anyone know of a way to view the public schema details outside of pgadmin or to identify what might be causing it to freeze. My database is effectively unaccessible until i can resolve this so any thoughts would be fantastic. Cheers Andy -- View this message in cont

[pgadmin-support] pgadmin freezes on expanding public schema after deleting VIEW

2011-06-16 Thread LPlateAndy
Hi, Using pgAdmin 1.12.3 (on postgreSQL 9 and with PostGIS 1.5 coincidentally). I have been working with creating VIEWS and this is working well. However, on a couple of occassions i have found that when i delete/drop the view using a query it runs for some time and if i abandon the query (probab