Re: create or replace view

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