Hi All i am trying to DROP the column but i keep getting this error.
ALTER TABLE institution DROP COLUMN name CASCADE; ERROR: ALTER TABLE / DROP COLUMN is not implemented
please help me in solving this issue.
Looks like Postgresql older than 7.x (7.3?)
You can't drop column this way. In older versions you can do this only by: create table temp (columns as you wish to have) insert into temp select * from old_table drop old_table alter table temp rename to old_table
Regards, Tomasz Myrta
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
