Re: create or replace view - Mailing list pgsql-hackers

From snpe
Subject Re: create or replace view
Date
Msg-id 200211141720.18743.snpe@snpe.co.yu
Whole thread Raw
In response to Re: create or replace view  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: create or replace view  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thursday 14 November 2002 05:22 pm, Bruno Wolff III wrote:
> On Thu, Nov 14, 2002 at 17:00:30 +0000,
>
>   snpe <snpe@snpe.co.yu> wrote:
> > On Thursday 14 November 2002 05:01 pm, Bruno Wolff III wrote:
> > > On Thu, Nov 14, 2002 at 16:49:42 +0000,
> > >
> > >   snpe <snpe@snpe.co.yu> wrote:
> > > > I want that 'create or replace view' work drop-create if view exists
> > > > else only create
> > >
> > > Why do you want this?
> >
> > Why 'create or replace' ?
>
> Why do you want create or replace to do a drop, then a create if the view
> exists but it is being changed in a way that will break any objects that
> refer to the old view?
>
> Are you trying to save typing a few characters or what?
Yes, it is 'create or replace view', not ?



pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: create or replace view
Next
From: Tom Lane
Date:
Subject: Re: Propose RC1 for Friday ...