Re: ERROR: volatile EquivalenceClass has no sortref

Поиск
Список
Период
Сортировка
От Ranjeet Dhumal
Тема Re: ERROR: volatile EquivalenceClass has no sortref
Дата
Msg-id CAFNnw=0rTUKR9atyYwj7=hs45R8x5ajpAddRy7CvnmNQy8J9Gw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: volatile EquivalenceClass has no sortref  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Ответы Re: ERROR: volatile EquivalenceClass has no sortref  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-general
Дерево обсуждения
Hi Laurenz ,

I got this error on two different tables , first one is empty and second one has near about 60k records , am using 9.0.1 version of postgres.
And when i dropped that both table and recreated with same data and structure  query ran successfully , am not able to understand how this is happening suddenly because for same table and everything  is working fine  without error .


On 21 November 2012 18:14, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Ranjeet Dhumal wrote:
> When am trying to query a table temp_table1(sms_type
varchar(20),sms_info varchar(100),sms_id integer)
> Query :: select sms_type,count(*) from  temp_table1 group by 1 order
by 2 desc;
> Then i got following errors , i dont know whats wrong in this .
> ERROR: volatile EquivalenceClass has no sortref
>
> This is my first post to forum , Please suggest me if i miss something
.

Do you get this error regardless of what is
in the table?  I tried on 9.2 with an empty table
and with one with a few random values and got no
error.

It would be helpful to know which PostgreSQL version
you have.
Can you construct a reproducible test case?

Yours,
Laurenz Albe



--
--Regards
  Ranjeet  R. Dhumal
 

В списке pgsql-general по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: ERROR: volatile EquivalenceClass has no sortref
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: ERROR: volatile EquivalenceClass has no sortref