Re: Can't drop a view ("view does not exist") that has an entry in "INFORMATION_SCHEMA.views"

From: "Klaus Hofeditz ]project-open[" <klaus(dot)hofeditz(at)project-open(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can't drop a view ("view does not exist") that has an entry in "INFORMATION_SCHEMA.views"
Date: 2014-11-17 22:10:35
Message-ID: 546A725B.70301@project-open.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Guillaume  splendid - tx! ./k<br>
<br>
On 17/11/2014 22:53, Guillaume Lelarge wrote:<br>
</div>
<blockquote
cite="mid:CAECtzeWLZ2tJDg=-Ax3Rj_LpAhtVaVaAbi1Gh+VCxVEAnu2KiA(at)mail(dot)gmail(dot)com"
type="cite">
<p dir="ltr">Le 17 nov. 2014 22:49, "Klaus Hofeditz
]project-open[" &lt;<a moz-do-not-send="true"
href="mailto:klaus(dot)hofeditz(at)project-open(dot)com">klaus(dot)hofeditz(at)project-open(dot)com</a>&gt;
a écrit :<br>
&gt;<br>
&gt; Hi guys, <br>
&gt; I need to drop a view in order  to alter a type of a
column: numeric(12,1) -&gt;  numeric(12,2): <br>
&gt;<br>
&gt; 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>
&gt;<br>
&gt; Trying to delete it, I get: <br>
&gt;<br>
&gt; projop=# drop view TransTasksCube;<br>
&gt; ERROR:  view "transtaskscube" does not exist<br>
&gt;<br>
&gt; FYI: VIEW also shows up in table INFORMATION_SCHEMA.views:
<br>
&gt;<br>
&gt; projop=# select table_name from INFORMATION_SCHEMA.views
where table_name like '%Trans%';<br>
&gt;    table_name<br>
&gt; ----------------<br>
&gt;  TransTasksCube<br>
&gt; (1 row)</p>
<p dir="ltr">You need double quotes because of the upper case
letters:</p>
<p dir="ltr">drop view "TransTasksCube";</p>
</blockquote>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.7 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2014-11-17 22:16:26 Re: Can't drop a view ("view does not exist") that has an entry in "INFORMATION_SCHEMA.views"
Previous Message Merlin Moncure 2014-11-17 21:57:58 Re: Managing Key Value tags on rows