From: | roopa perumalraja <roopabenzer(at)yahoo(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Help in altering the column lenght |
Date: | 2006-12-29 01:05:04 |
Message-ID: | 953822.58722.qm@web50814.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2006-12-29 11:59:45 | Re: help with version checking |
Previous Message | Chris Dunworth | 2006-12-28 18:32:51 | Re: help with version checking |