On Wed, Mar 19, 2014 at 11:27 PM, Emi Lu wrote:
> Is there a way to change a table column from varchar(n) to varchar with
> views depended on it.
Nope. You cannot update the data type of a table column if it is used by a view.
=# create table aa (a varchar(4));
CREATE TABLE
=# create view aav as s
Hello list,
Is there a way to change a table column from varchar(n) to varchar with
views depended on it.
The problem is that I do not want to drop and re-create all views
dependencies. I am looking for a way/command that can change the column
type and all views will be auto updated as well.
