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