Re: alter + preserving dependencies - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: alter + preserving dependencies
Date
Msg-id 48209512.3040301@agliodbs.com
Whole thread Raw
In response to alter + preserving dependencies  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: alter + preserving dependencies  (Andrew Dunstan <andrew@dunslane.net>)
List 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


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: alter + preserving dependencies
Next
From: Andrew Dunstan
Date:
Subject: Re: alter + preserving dependencies