Re: pg_dump versus views and opclasses

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Brendan Jurd" <direvus(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_dump versus views and opclasses
Date: 2009-01-18 06:02:01
Message-ID: 23516.1232258521@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Brendan Jurd" <direvus(at)gmail(dot)com> writes:
> Does this also explain the extra-weird output from HEAD, with the <=
> and = operators sorting earlier than the view, but the rest of the
> operators sorting after it?

No, that comes from the fact that we have dependencies on those two
operators (but not the whole opclass) in SortGroupClause. So they
get forced to come out before the view, but the rest do not.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-01-18 06:08:52 Re: VARSIZE - why omit VARLEN?
Previous Message Andrew Chernow 2009-01-18 02:27:18 VARSIZE - why omit VARLEN?