<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=windows-1252">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi guys, <br>
I need to drop a view in order to alter a type of a column:
numeric(12,1) -> numeric(12,2): <br>
<br>
ERROR: cannot alter type of a column used by a view or rule
DETAIL: rule _RETURN on view "TransTasksCube" depends on column
"billable_units"<br>
<br>
Trying to delete it, I get: <br>
<br>
projop=# drop view TransTasksCube;<br>
ERROR: view "transtaskscube" does not exist<br>
<br>
FYI: VIEW also shows up in table INFORMATION_SCHEMA.views: <br>
<br>
projop=# select table_name from INFORMATION_SCHEMA.views where
table_name like '%Trans%';<br>
table_name<br>
----------------<br>
TransTasksCube<br>
(1 row)<br>
<br>
Appreciate your help!<br>
Klaus <br>
<br>
<div class="moz-signature">-- <br>
<title></title>
<span style="font-size:8pt; font-family:'Verdana'; color:#666666;
text-decoration:none;">
Klaus Hofeditz<br>
Co-Founder ]project-open[<br>
<br>
<strong>Web:</strong> <a href="http://www.project-open.com">http://www.project-open.com</a>
<a href="http://www.project-open.org">http://www.project-open.org</a><br>
<strong>LinkedIn:</strong> <a
href="http://www.linkedin.com/pub/klaus-hofeditz/2/604/871">http://www.linkedin.com/pub/klaus-hofeditz/2/604/871</a><br>
<strong>XING:</strong> <a
href="https://www.xing.com/profile/Klaus_Hofeditz">https://www.xing.com/profile/Klaus_Hofeditz</a><br>
<strong>Twitter:</strong> <a href="https://twitter.com/projop">https://twitter.com/projop</a><br>
</span>
</div>
</body>
</html>