Hi Guillaume splendid - tx! ./k
On 17/11/2014 22:53, Guillaume Lelarge wrote:
<blockquote
cite="mid:CAECtzeWLZ2tJDg=-Ax3Rj_LpAhtVaVaAbi1Gh+VCxVEAnu2KiA@mail.gmail.com"
type="cite">
Le 17 nov. 2014 22:49, "Klaus Hofeditz
]project-open[" <<a moz-do-not-send="true"
href="mailto:klaus.hofeditz@project-open.com">klaus.hofeditz@project-open.com>
a écrit :
>
> 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)
You need double quotes because of the upper case
letters:
drop view "TransTasksCube";