Re: deleting dependencies - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: deleting dependencies
Date
Msg-id 080301c2d94b$93db42b0$6500a8c0@fhp.internal
Whole thread Raw
In response to deleting dependencies  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> > I've been looking at the dependency API and I notice that there is a
> > function to delete ALL dependencies on an object and a function to add a
> > dependency, but there doesn't seem to be any way of deleting a
dependency
> > between two _particular_ objects.
>
> In the ALTER cases that have been implemented so far, it seemed easiest
> to wipe the full set of dependencies and then regenerate them from the
> altered object.  I think you will find the same is true of altering
> column type.  To take just one example, the column default expression
> (if any) almost certainly has to be replaced too, and it may contain
> dependencies.

Phase 1 (which I'm currently doing) will do binary-compatible casts only.
After that, I have to start using code from cluster.c to rewrite the table
methinks...and everything gets a *lot* harder...

Chris




pgsql-hackers by date:

Previous
From: Kevin Brown
Date:
Subject: Re: request for sql3 compliance for the update command
Next
From: "Christopher Kings-Lynne"
Date:
Subject: contrib/adddepend