Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I imported shp to postgis 2.0.1 with shp2pgsql and chose to use geography instead of geometry. However, now when I try to drop the table, the pgadmin/sql console/phpPgAdmin freezes. I can't neither truncate it or change the columns.

Any help would be appreciated :-).

share|improve this question
try "drop table tablename cascade;" from query window – simplexio Dec 5 '12 at 13:49
Tried before, doesn't work. – Michal Zimmermann Dec 5 '12 at 13:51
Try to VACUUM ... Can you operates the data? ( select, update, and so ... ) – Magno C Dec 5 '12 at 13:58
Can you login into the database using psql? – djq Dec 5 '12 at 15:15
At this point i would login to Freenode and #postgresql or #postgis and ask it there. – simplexio Dec 10 '12 at 13:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.