Richard Neill ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is.
Short Description Need "Alter table drop column" Long Description Please can we have the option of "Alter table drop column "? Otherwise, correcting a simple mistake of setting up a column as varchar 50 and discovering later that varchar 70 would have been better requires a complete copy of the table to be made via select into. This also breaks sequences, and primary keys. The obvious workaround is alter table add column new, update table set new=old, alter table drop column old, alter table column new rename to old. But the 3rd step can't be done! Sample Code No file was uploaded with this report ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
