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

"Klaus Hofeditz ]project-open[" <klaus.hofeditz@xxxxxxxxxxxxxxxx> · Mon, 17 Nov 2014 22:46:27 +0100



    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 

    
    -- 

      
        Klaus Hofeditz

        Co-Founder ]project-open[

        
        Web: http://www.project-open.com
        http://www.project-open.org

        LinkedIn: http://www.linkedin.com/pub/klaus-hofeditz/2/604/871

        XING: https://www.xing.com/profile/Klaus_Hofeditz

        Twitter: https://twitter.com/projop