From: | Ranjeet Dhumal <jeetu(dot)dhumal(at)gmail(dot)com> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: volatile EquivalenceClass has no sortref |
Date: | 2012-11-21 12:54:10 |
Message-ID: | CAFNnw=0rTUKR9atyYwj7=hs45R8x5ajpAddRy7CvnmNQy8J9Gw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(dot)albe(at)wien(dot)gv(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2012-11-21 13:34:25 | Re: ERROR: volatile EquivalenceClass has no sortref |
Previous Message | Albe Laurenz | 2012-11-21 12:44:52 | Re: ERROR: volatile EquivalenceClass has no sortref |
From | Date | Subject | |
---|---|---|---|
Next Message | Amit kapila | 2012-11-21 13:15:53 | Re: [WIP PATCH] for Performance Improvement in Buffer Management |
Previous Message | Albe Laurenz | 2012-11-21 12:44:52 | Re: ERROR: volatile EquivalenceClass has no sortref |