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

From snpe
Subject Re: create or replace view
Date
Msg-id 200211150209.13246.snpe@snpe.co.yu
Whole thread Raw
In response to Re: create or replace view  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: create or replace view  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
On Thursday 14 November 2002 10:36 pm, Stephan Szabo wrote:
> 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.
>
>
Can PostgreSQL recreate dependecies automaticly or say 'object is not valid'

regards
Haris Peco


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: FW: PostgreSQL 7.3 Platform Testing
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: create or replace view