Re: URGENT!!! changing Column size - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: URGENT!!! changing Column size
Date
Msg-id 3F9D6B8B.1050303@klaster.net
Whole thread Raw
In response to URGENT!!! changing Column size  (mohan@physics.gmu.edu)
List pgsql-sql
Dnia 2003-10-27 19:33, Użytkownik btober@seaworthysys.com napisał:
> I've seen these sets of steps suggested in response to other such
> inquires, but doesn't this break views on the associated table, or may
> just not work because if a view dependency exists?

It would be the second case (it won't work at all). You can use 
"cascade" when dropping column. After this you need to recreate views 
dropped together with a column.

Regards,
Tomasz Myrta



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax
Next
From: mohan@physics.gmu.edu
Date:
Subject: Error with DROP column