snpe <snpe(at)snpe(dot)co(dot)yu> writes:
> On Thursday 14 November 2002 05:22 pm, Bruno Wolff III wrote:
>> Are you trying to save typing a few characters or what?
> Yes, it is 'create or replace view', not ?
The statement was not invented to save a few characters of typing.
It was invented to allow people to make internal changes to view
definitions without breaking other objects that refer to the view.
If we made it automatically drop and recreate the view then we'd
be defeating the purpose.
regards, tom lane