Re: pg_dump versus views and opclasses

Поиск
Список
Период
Сортировка
От Brendan Jurd
Тема Re: pg_dump versus views and opclasses
Дата
Msg-id 37ed240d0901170733g70ca792anc6f16b3b57a9afeb@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dump versus views and opclasses  ("Brendan Jurd" <direvus@gmail.com>)
Ответы Re: pg_dump versus views and opclasses  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Brendan Jurd"
Дата:
Сообщение: Re: pg_dump versus views and opclasses
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump versus views and opclasses