Re: create or replace view

From: snpe <snpe(at)snpe(dot)co(dot)yu>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: create or replace view
Date: 2002-11-14 17:20:18
Message-ID: 200211141720.18743.snpe@snpe.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)snpe(dot)co(dot)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(at)snpe(dot)co(dot)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 ?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruno Wolff III 2002-11-14 17:22:59 Re: create or replace view
Previous Message Bruno Wolff III 2002-11-14 17:01:36 Re: create or replace view