From: Tomasz Myrta <jasiek@klaster.net>
To: btober@seaworthysys.com
Cc: mohan@physics.gmu.edu
Cc: pgsql-sql@postgresql.org
Subject: Re: URGENT!!! changing Column size
Date: Mon, 27 Oct 2003 20:01:31 +0100
Message-ID: <3F9D6B8B.1050303@klaster.net> (raw)
In-Reply-To: <1608.192.168.123.2.1067279639.squirrel@$HOSTNAME>
References: <64184.138.88.163.115.1067274631.squirrel@physics.gmu.edu>
<3F9D59FC.8010407@klaster.net>
<1608.192.168.123.2.1067279639.squirrel@$HOSTNAME>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasiek@klaster.net, btober@seaworthysys.com, mohan@physics.gmu.edu
Subject: Re: URGENT!!! changing Column size
In-Reply-To: <3F9D6B8B.1050303@klaster.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox