Re: pg_dump versus views and opclasses - Mailing list pgsql-hackers

From Brendan Jurd
Subject Re: pg_dump versus views and opclasses
Date
Msg-id 37ed240d0901170733g70ca792anc6f16b3b57a9afeb@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump versus views and opclasses  ("Brendan Jurd" <direvus@gmail.com>)
Responses Re: pg_dump versus views and opclasses  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, Jan 18, 2009 at 1:41 AM, Brendan Jurd <direvus@gmail.com> wrote:
> ... but I'm confused as to why 8.4
> doesn't freak out when told to create a view it doesn't actually know
> how to execute.  Have the rules for evaluating views changed?
>

Update.  Turns out that 8.4 DOES know how to execute the view.  If you
try to group on a user-defined composite type, 8.4 just goes ahead and
groups it, rather than giving the old "could not identify an ordering
operator" error.

Which renders the whole idea of creating my own opclass for the type
very much bunk.

What sorcery is this?  Does 8.4 add some kind of default ordering
strategy for composite types?

Cheers,
BJ


pgsql-hackers by date:

Previous
From: "Brendan Jurd"
Date:
Subject: Re: pg_dump versus views and opclasses
Next
From: Tom Lane
Date:
Subject: Re: pg_dump versus views and opclasses