Re: create or replace view

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: snpe <snpe(at)snpe(dot)co(dot)yu>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: create or replace view
Date: 2002-11-14 17:22:59
Message-ID: 20021114172259.GA22469@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-11-14 17:34:31 Re: Propose RC1 for Friday ...
Previous Message snpe 2002-11-14 17:20:18 Re: create or replace view