Re: create or replace view

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
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 22:36:34
Message-ID: 20021114143053.U98908-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Thu, 14 Nov 2002, snpe wrote:

> Problem is when I want change view (or functions) with a lot of dependecies
> I must drop and recreate all dependent views (or functions) - I want add only
> one column in view
> I don't know if solution hard for that.

Well, doing create or replace as a drop/create might very well do the same
thing, and even if it got the same oid, we'd have to be really sure that
nothing would misbehave upon receiving that extra column before allowing
it for purposes of avoiding recreation of dependencies.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Edwards 2002-11-14 22:40:23 Re: c/sql
Previous Message snpe 2002-11-14 21:45:54 Re: create or replace view