Re: ERROR: volatile EquivalenceClass has no sortref - Mailing list pgsql-general

From Albe Laurenz
Subject Re: ERROR: volatile EquivalenceClass has no sortref
Date
Msg-id D960CB61B694CF459DCFB4B0128514C208B8852F@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: ERROR: volatile EquivalenceClass has no sortref  (Ranjeet Dhumal <jeetu.dhumal@gmail.com>)
Responses Re: ERROR: volatile EquivalenceClass has no sortref  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
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 understand how this is happening suddenly because for
same table and everything  is
> working fine  without error .

Try to find out under what condition the problem occurs.
A reproducible test case would be most helpful.

Yours,
Laurenz Albe


pgsql-general by date:

Previous
From: Ranjeet Dhumal
Date:
Subject: Re: ERROR: volatile EquivalenceClass has no sortref
Next
From: Peter Kroon
Date:
Subject: output inserted