[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] 7.5 features
From:       snpe <snpe () snpe ! co ! yu>
Date:       2003-12-15 16:45:38
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]