On Monday 15 December 2003 08:30 am, Tino Wildenhain wrote:
> Hi Harsi,
>
> snpe schrieb:
> > On Sunday 14 December 2003 03:51 pm, Tino Wildenhain wrote:
> >>Hi snpwhatever,
> >>
> >>snpe wrote:
> >>>Hello,
> >>> Can PostgreSQL resolve object dependencies automatic
> >>>If we delete any object then Postgresql automatic resolve status (valid
> >>>or invalid objects)
> >>
> >>You mean plain old foreign keys?
> >
> > Hi Tino,
> > not only foreign key, for all objects - when I create view tabv for table
> > tab I can't delete table tab - I want that PostgreSQL delete tab and set
> > tabv to invalid When I create tab again, then view tabv become valid
> > (maybe).
> > It is important for more objects (functions, procedures, views etc) and
> > change offten. I don't want delete all dependencies objects
>
> I dont think its wise to change database structure that often.
> And I got the impression its a job for case-tools and support
> scripts rather then the database itself.
> Database schould focus on data integrity (which it does)
> and not pay too much attention to schema issues beside whats
> needed for data integrity.
>
Hello,
If I have btw view with 10 dependent functions and 10 dependent table
I want change one column in view - I must delete all 20 objects for this.
regards
Haris Peco
