Thread: 7.5 features
Hello, Can PostgreSQL resolve object dependencies automatic If we delete any object then Postgresql automatic resolve status (valid or invalid objects) regards
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? Regards Tino Wildenhain
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. Regards Tino Wildenhain
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