From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rajesh Kumar Mallah <mallah@trade-india.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.
Date: Thu, 17 Jun 2004 09:36:01 -0400
Message-ID: <12327.1087479361@sss.pgh.pa.us> (raw)
In-Reply-To: <40D1136F.3040708@trade-india.com>
References: <40CFFC68.5090704@trade-india.com>
<21524.1087394109@sss.pgh.pa.us>
<40D06096.90200@trade-india.com>
<22477.1087400110@sss.pgh.pa.us>
<40D06D1E.5000803@trade-india.com>
<23874.1087409853@sss.pgh.pa.us>
<40D1136F.3040708@trade-india.com>
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> Yep the problem of original posting could be replicated on
> disabling hash aggregates. On disabling i could get the repeated rows.
Okay. What I suspect is happening is that there are entries in the
column that are equal according to the datatype's comparison function,
but are not bitwise equal and therefore yield different hash codes.
This makes it a crapshoot whether they are seen to be equal or not
when hash aggregation is used. We identified a similar bug in the
inet/cidr datatypes just a few weeks ago.
What exactly is the datatype of the "name" column? If it's a text
type, what database encoding and locale settings (LC_COLLATE/LC_CTYPE)
are you using? Can you investigate exactly what's stored within each
of these groups of matching names?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, mallah@trade-india.com
Subject: Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.
In-Reply-To: <12327.1087479361@sss.pgh.pa.us>
References: <40CFFC68.5090704@trade-india.com> <21524.1087394109@sss.pgh.pa.us> <40D06096.90200@trade-india.com> <22477.1087400110@sss.pgh.pa.us> <40D06D1E.5000803@trade-india.com> <23874.1087409853@sss.pgh.pa.us> <40D1136F.3040708@trade-india.com> <12327.1087479361@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox