Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id F36919FA311
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 28 Dec 2006 21:05:12 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 48342-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 28 Dec 2006 21:05:07 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from web50814.mail.yahoo.com (web50814.mail.yahoo.com
	[206.190.39.120])
	by postgresql.org (Postfix) with SMTP id 409589F9F08
	for <pgsql-sql@postgresql.org>; Thu, 28 Dec 2006 21:05:06 -0400 (AST)
Received: (qmail 59637 invoked by uid 60001); 29 Dec 2006 01:05:05 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=ZQArOF0TcySALPD0Mc/ohPHZ5QDJwvmOVqqKg80zvKITE/5solNQbWlGWGhBAgOw4J26qOgk6Tnodp2umlQYPiNfTREypErb4X7A/MJ7slR++xMrPS8wLMxS5xLK/8l21U/gnIF6ttQ7TiVB6PBRhhQGCTwmvpuNlOaOgDRkG/g=;
X-YMail-OSG: 
 ZubMghwVM1lyGyWrafa5OJvprtP44A9Dytu663Ld9SA7SIC1R0VyxgCIzpntG6eINubx0hI3vAVQLJC720DvTd4eWnnJjplpQcsVTeps20ryrQ7Ev9IUs1mf0kMwVUxN65_xxMEfnllb3ceGQBcXdGG_.0UhnJvzusnVoojIUq2Wi9SD1U3UnG2tDiMg
Received: from [203.134.174.70] by web50814.mail.yahoo.com via HTTP;
	Thu, 28 Dec 2006 17:05:04 PST
Date: Thu, 28 Dec 2006 17:05:04 -0800 (PST)
From: roopa perumalraja <roopabenzer@yahoo.com>
Subject: Help in altering the column lenght
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-712794107-1167354304=:58722"
Content-Transfer-Encoding: 8bit
Message-ID: <953822.58722.qm@web50814.mail.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.059 tagged_above=0 required=5 tests=AWL, BAYES_00,
	DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_MESSAGE
X-Spam-Level: *
X-Archive-Number: 200612/184
X-Sequence-Number: 27140

--0-712794107-1167354304=:58722
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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 
--0-712794107-1167354304=:58722
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div>Hi all,</div>  <div>&nbsp;</div>  <div>I am trying to alter the column lenght of the table which has 500 child tables by sql command.</div>  <div>&nbsp;</div>  <div>alter table ticks alter column qualifiers type varchar(500);</div>  <div>&nbsp;</div>  <div>the error is </div>  <div>&nbsp;</div>  <div>ERROR:&nbsp; cannot alter type of a column used by a view or rule<BR>DETAIL:&nbsp; rule ticks_insert_20070228 on table ticks depends on column "qualifiers"</div>  <div>&nbsp;</div>  <div>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&nbsp;do it?? Thanks a lot in advance.</div><p>&#32;__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com 
--0-712794107-1167354304=:58722--