Re: URGENT!!! changing Column size

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: btober(at)seaworthysys(dot)com
Cc: mohan(at)physics(dot)gmu(dot)edu, pgsql-sql(at)postgresql(dot)org
Subject: Re: URGENT!!! changing Column size
Date: 2003-10-27 19:01:31
Message-ID: 3F9D6B8B.1050303@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dnia 2003-10-27 19:33, Użytkownik btober(at)seaworthysys(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message mohan 2003-10-27 19:35:44 Error with DROP column
Previous Message Gary Stainburn 2003-10-27 17:50:03 Re: URGENT!!! changing Column size