Bernd Helmle wrote:
>
> On Thu, 11 Jan 2007 06:36:34 -0800 (PST), Richard Broersma Jr <rabroersma@yahoo.com> wrote:
>
>
>> Either way. I like to create sql files with all of the DDL for creating
>> the view and rules.
>> Overtime, if I need to change my view or reconfigure the rules, I can edit
>> my sql file and then
>> call it up in psql using "\e <view_def.sql>"
>>
>> I use the "CREATE OR REPLACE VIEW" syntax to achieve this.
>>
>>
>
> Additional note: REPLACE doesn't work if you are going to change the
> list/type/name of your view columns. In 8.2 and above you could use
> DROP VIEW IF EXISTS combined with a following CREATE VIEW, instead.
>
Does anybody have a reason why this is the case. I can change all those
things for a table without dropping it, why can't I do the same on a view?
> Bernd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
>