On Thu, Nov 22, 2012 at 11:08 AM, Ranjeet Dhumal wrote:
> Hi Tom ,
>
> Sorry but i didn't understand that If this is a bug from postgres version
> then how the same query will be worked if i recreated the tables and with
> same version of postgres.
>
>
This could be related to the plans that are
Hi Tom ,
Sorry but i didn't understand that If this is a bug from postgres version
then how the same query will be worked if i recreated the tables and with
same version of postgres.
On 21 November 2012 19:53, Tom Lane wrote:
> Alban Hertroys writes:
> >> Ranjeet Dhumal wrote:
> > records ,
Alban Hertroys writes:
>> Ranjeet Dhumal wrote:
> records , am using 9.0.1 version of postgres.
> This is quite possibly your problem: You're 9 bugfix releases behind
> on a .0 release. You should be at 9.0.10 at least.
Yes. I seem to recall fixing a bug with exactly this symptom.
Please update
> Ranjeet Dhumal wrote:
>> records , am using 9.0.1 version of postgres.
This is quite possibly your problem: You're 9 bugfix releases behind
on a .0 release. You should be at 9.0.10 at least.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.
--
Se
Ranjeet Dhumal wrote:
> 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 understa
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
h
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 Equiva
Hi All ,
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 s
