A table in my PostGIS database (PostgreSQL 9.3.5) had the wrong geometry-type, therefore I wanted to change the geometry type. I tried to do this by dropping the geometry column like this:
ALTER TABLE xxx.my_table
DROP COLUMN geometry_column;
After which I would have added a new geometry column of the correct type.
In hindsight, I should probably have used
ALTER COLUMN, however this didn't occur to me at the time.
The query started to run, however it never finished, so I had to stop the execution. Following this, every time I click on the table from within pgAdmin, the program crashes. I have tried using DROP TABLE to delete the table, but the query just runs without finishing. I also tried deleting the entire schema from within pgAdmin, however this also causes a crash.
The program gets stuck when "retrieving details" on the table, so I suspect the table is corrupt in some way. We have a backup of the schema in a working state, however using the restore functionality in pgAdmin doest not seem to work either.
Is there anyway to "fix" the table or force delete it in any way?