Re: pg_dump versus views and opclasses

On Fri, Jan 16, 2009 at 9:01 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Brendan Jurd" <direvus@gmail.com> writes:
>>  * It seems there's no pg_depend entry for
>> types/functions/operators/opclasses that the view depends on, unless
>> they are part of the SELECT list.
>
> What PG version exactly?  We've been moving towards fuller
> representation of the semantics in the parse tree over time,
> so that's a very relevant question.
>

This is all on 8.3.3.

> FWIW I think this should be pretty much fixed as of CVS HEAD, because
> all of the sorting/grouping semantics are now normalized in
> SortGroupClauses and find_expr_references() does know about them.
> Can you extract a test case from your problem DB so we can verify
> nothing got missed?

Okay, I'll work on getting a test case together and try it against
HEAD and 8.3.5 for good measure.  I'll post the results here.

Cheers,
BJ