From: | Attila Kevei <attila(dot)kevei(at)mail(dot)goodwill(dot)hu> |
---|---|
To: | Postgres SQL list <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: select returns no line |
Date: | 2001-01-24 09:10:33 |
Message-ID: | 980327433.3a6e9c092718d@www.goodwill.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
This locale-thing sounds good...:-)
As I remember, we've changed the locale settings after the creation of the
table.
The former opinions (space after the text, value length, etc.) didn't help us
too much.
Anyway, thanks to all.
So, I try to re-create the index.
Attila
Quoting Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Attila Kevei <attila(dot)kevei(at)mail(dot)goodwill(dot)hu> writes:
> > Our database has a SELECT problem using varchar columns in WHERE
> clause
> > (but not in all rows!!!).
> > We can fix the whole table (or just the row) as shown below but later
> it
> > seems wrong again (and after the fix the row isn't UPDATEd).
>
> Very bizarre. Is the bogus SELECT using an index? (Check with EXPLAIN
> if you're not sure.) I am suspicious that it is using a corrupted
> index. Try dropping and rebuilding the index and see if the problem
> persists.
>
> If you have built Postgres with locale support, an easy way to get
> corrupted indexes on text/char/varchar columns is to start the
> postmaster with different locale environment variables at different
> times. Different locales mean different logical sort orders, and
> a btree index that is out of order is corrupt by definition. The
> most common way of shooting yourself in the foot is to sometimes start
> the postmaster from a boot script, and sometimes start it by hand from
> a user login that has different locale environment than the boot script.
> 7.1 will have some defenses against this, but in older releases you
> have to be careful.
>
> regards, tom lane
>
--
x- kisix(at)swi(dot)hu -x- attila(dot)kevei(at)goodwill(dot)hu -x- kisiksz(at)westel900(dot)net -x
From | Date | Subject | |
---|---|---|---|
Next Message | Ramesh H R | 2001-01-24 09:12:55 | How to change the ownership of the table? |
Previous Message | Peter T Mount | 2001-01-24 09:08:07 | Re: [SQL] postgresql.largeobject package |