Re: Underlying view columns?

Tom Lane wrote:
> Fredrik Olsson <fredrik(dot)olsson(at)treyst(dot)se> writes:
>
>> Have I misunderstood the concept of pg_depend? Can it even be used for
>> what I intend, and if not in what direction should I be searching next?
>>
>
> What you missed is that the per-column dependencies you are looking for
> go from the view's rewrite rule to the underlying table.
>
<snip>
> There isn't anything in pg_depend that would let you associate
> particular columns of bar's output with particular dependencies, so I'm
> not sure it really will help for your problem. I don't think there's
> any way you could find that out except by parsing the stored rule
> expression, which I would strongly NOT recommend, as your code will
> inevitably break every time we modify expression trees (which is often).
>
> regards, tom lane
>
Thanks for the good explanation. I resort to keep depending on
name-similarities, with added exceptions for legacy objects. That and
some well documented guidelines for this projects future additions
solves the problem, in a way that looks good to the end user at least :).

--
//Fredrik Olsson
Treyst AB
+46-19-362182
fredrik(dot)olsson(at)treyst(dot)se