Re: deleting dependencies
От | Christopher Kings-Lynne |
---|---|
Тема | Re: deleting dependencies |
Дата | |
Msg-id | 080301c2d94b$93db42b0$6500a8c0@fhp.internal обсуждение исходный текст |
Ответ на | deleting dependencies ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>) |
Список | 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 по дате отправления: