Re: 7.5 features

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 7.5 features
Date: 2003-12-15 08:30:03
Message-ID: 3FDD710B.5040103@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2003-12-15 09:02:18 Re: [GENERAL] Reordering results for a report
Previous Message Florian Reiser 2003-12-15 07:55:58 Re: FoxPro Vs. PostgreSQL