Re: sorting/grouping/(non-)unique indexes bug

From: "Alexey V(dot) Borzov" <borz_off(at)rdw(dot)ru>
To: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sorting/grouping/(non-)unique indexes bug
Date: 2002-06-07 18:09:13
Message-ID: 1852175648.20020607220913@rdw.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Jean-Luc,

Friday, June 07, 2002, 8:26:55 PM, you wrote:

JLL> Unbelievable, but you may have a couple of record with null user_email.

JLL> Try:

JLL> select * from broken where user_email is null;
JLL> select * from reg_user where user_email is null;

Nope, there are none. Which is expected, 'cause user_email was
declared not null:

rdw=# select * from reg_user where user_email is null;
user_id | user_email | user_passwd | user_active | user_allow_pauth | user_full_name | user_pseudonym | user_who
---------+------------+-------------+-------------+------------------+----------------+----------------+----------
(0 rows)

rdw=# select * from broken where user_email is null;
user_email
------------
(0 rows)

And the locale is probably OK, too. I tried dumping the table in
question and passing it through sort/uniq. It worked OK, unlike GROUP BY in
Postgres.

JLL> Alexey Borzov wrote:
>>
>> Greetings!
>>
>> Before I present the following, I must say that 'simple' index
>> corruption is highly improbable; the server did not suffer hard
>> reboots.
>>
[skip]

--
Yours, Alexey V. Borzov, webmaster of RDW.ru

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Seidman 2002-06-07 18:36:35 Re: Are globally defined constants possible at all ?
Previous Message Neil Conway 2002-06-07 18:00:59 Re: Slow connection