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.a...@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