On Fri, Jan 16, 2009 at 9:01 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > "Brendan Jurd" <dire...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
