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:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 18. Dezember 2002 17:42
An: "Böhm, Sebastian (Vendor)"
Cc: '[EMAIL PROTECTED]'
Betreff: Re: [BUGS] strange problem
=?iso-8859-1?Q?=22B=F6hm=2C_Sebastian_=28Vendor=29=22?= <[EMAIL PROTECTED]> 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
