Can't drop a view ("view does not exist") that has an entry in "INFORMATION_SCHEMA.views" - Mailing list pgsql-general

From Klaus Hofeditz ]project-open[
Subject Can't drop a view ("view does not exist") that has an entry in "INFORMATION_SCHEMA.views"
Date
Msg-id 546A6CB3.5050100@project-open.com
Whole thread Raw
Responses Re: Can't drop a view ("view does not exist") that has an entry in "INFORMATION_SCHEMA.views"
List pgsql-general
Hi guys,
    I need to drop a view in order  to alter a type of a column:
    numeric(12,1) ->  numeric(12,2):

    ERROR:  cannot alter type of a column used by a view or rule
    DETAIL:  rule _RETURN on view "TransTasksCube" depends on column
    "billable_units"

    Trying to delete it, I get:

    projop=# drop view TransTasksCube;
    ERROR:  view "transtaskscube" does not exist

    FYI: VIEW also shows up in table INFORMATION_SCHEMA.views:

    projop=# select table_name from INFORMATION_SCHEMA.views where
    table_name like '%Trans%';
       table_name
    ----------------
     TransTasksCube
    (1 row)

    Appreciate your help!
    Klaus

    --

      <span style="font-size:8pt; font-family:'Verdana'; color:#666666;
        text-decoration:none;">
        Klaus Hofeditz
        Co-Founder ]project-open[

        Web: http://www.project-open.com
        http://www.project-open.org
        LinkedIn: <a

href="http://www.linkedin.com/pub/klaus-hofeditz/2/604/871">http://www.linkedin.com/pub/klaus-hofeditz/2/604/871
        XING: <a
          href="https://www.xing.com/profile/Klaus_Hofeditz">https://www.xing.com/profile/Klaus_Hofeditz
        Twitter: https://twitter.com/projop

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Re: Managing Key Value tags on rows
Next
From: Guillaume Lelarge
Date:
Subject: Re: Can't drop a view ("view does not exist") that has an entry in "INFORMATION_SCHEMA.views"