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

From Stephan Szabo
Subject Re: create or replace view
Date
Msg-id 20021114143053.U98908-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: create or replace view  (snpe <snpe@snpe.co.yu>)
Responses Re: create or replace view  (snpe <snpe@snpe.co.yu>)
List 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.




pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: Propose RC1 for Friday ...
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: RC1?