Re: strange problem

Hi,

I did reindex, vacuum , dump/import, ...
I also tried 7.3.1

-->> It happens only with btree index on that column, without index it
works, with hash index also no problem.

This happend to 0.3% of all rows in this table, after dump/import exactly
the same rows were affected.

Can somebody tell me how to import a 7.3(.1) dump into 7.2.3 ?
It gives errors on import, so I cannot try it on 7.2.3.

Hope that helps.

Sebastian Böhm
Friendscout24

-----Ursprüngliche Nachricht-----
Von: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Gesendet: Mittwoch, 18. Dezember 2002 17:42
An: "Böhm, Sebastian (Vendor)"
Cc: 'pgsql-bugs(at)postgresql(dot)org'
Betreff: Re: [BUGS] strange problem

=?iso-8859-1?Q?=22B=F6hm=2C_Sebastian_=28Vendor=29=22?=
<sebastian(dot)boehm(at)friendscout24(dot)de> writes:
> ici=3D# select id,pseudonym from user_all where pseudonym =3D
> 'autologin_funkey';
> id | pseudonym
> ----+-----------
> (0 rows)

> ici=3D# select id,pseudonym from user_all where pseudonym ~
> '^autologin_funkey$';
> id | pseudonym
> ------+------------------
> 6881 | autologin_funkey
> (1 row)

That's pretty bizarre. Can you give a procedure for reproducing this
from a standing start?

regards, tom lane