Re: alter + preserving dependencies

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: alter + preserving dependencies
Date: 2008-05-06 17:27:46
Message-ID: 48209512.3040301@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew Dunstan wrote:
>
> I have a client who is looking for a way to be able to alter objects
> without having to recreate (say, from a dump) all the objects in a
> possibly large dependency tree rooted at the object. Of course, if the
> alteration invalidates the dependency, than this operation should fail,
> but adding a column to a view or table (which is our most common case)
> should arguably be a benign operation that shouldn't fail because of
> dependencies.
>
> I couldn't see anything in the TODO list that seemed appropriate, in a
> quick scan.

I don't follow you. I can currently add a column, without breaking
either foriegn keys or inheritance. What's the problem?

--Josh

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-05-06 17:35:40 Re: alter + preserving dependencies
Previous Message Andrew Dunstan 2008-05-06 17:14:16 alter + preserving dependencies