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

Поиск
Список
Период
Сортировка
От Klaus Hofeditz ]project-open[
Тема Can't drop a view ("view does not exist") that has an entry in "INFORMATION_SCHEMA.views"
Дата
Msg-id 546A6CB3.5050100@project-open.com
обсуждение исходный текст
Ответы Re: Can't drop a view ("view does not exist") that has an entry in "INFORMATION_SCHEMA.views"  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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 по дате отправления:

Предыдущее
От: Tim Uckun
Дата:
Сообщение: Re: Managing Key Value tags on rows
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Can't drop a view ("view does not exist") that has an entry in "INFORMATION_SCHEMA.views"