Hi all, I am trying to alter the column lenght of the table which has 500 child tables by sql command. alter table ticks alter column qualifiers type varchar(500); the error is ERROR: cannot alter type of a column used by a view or rule DETAIL: rule ticks_insert_20070228 on table ticks depends on column "qualifiers" Is the only option is to drop the rules then alter the table and again add the rules or is there any other option to do it?? Thanks a lot in advance.
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com