From: roopa perumalraja <roopabenzer@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Help in altering the column lenght
Date: Thu, 28 Dec 2006 17:05:04 -0800 (PST)
Message-ID: <953822.58722.qm@web50814.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: roopabenzer@yahoo.com
Subject: Re: Help in altering the column lenght
In-Reply-To: <953822.58722.qm@web50814.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox