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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])