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