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"
|
| Список | 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 по дате отправления: