From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Ranjeet Dhumal *EXTERN*" <jeetu(dot)dhumal(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ERROR: volatile EquivalenceClass has no sortref |
Date: | 2012-11-21 12:44:52 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C208B884E5@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ranjeet Dhumal | 2012-11-21 12:54:10 | Re: ERROR: volatile EquivalenceClass has no sortref |
Previous Message | Ranjeet Dhumal | 2012-11-21 12:37:19 | Fwd: ERROR: volatile EquivalenceClass has no sortref |
From | Date | Subject | |
---|---|---|---|
Next Message | Ranjeet Dhumal | 2012-11-21 12:54:10 | Re: ERROR: volatile EquivalenceClass has no sortref |
Previous Message | Ranjeet Dhumal | 2012-11-21 12:37:19 | Fwd: ERROR: volatile EquivalenceClass has no sortref |