<p><font size="2">Hi,</font><p><font size="2">I did reindex, vacuum , dump/import, ... </font><br /><font size="2">I
alsotried 7.3.1</font><p><font size="2">-->> It happens only with btree index on that column, without index it
works,with hash index also no problem.</font><p><font size="2">This happend to 0.3% of all rows in this table, after
dump/importexactly the same rows were affected.</font><p><font size="2">Can somebody tell me how to import a 7.3(.1)
dumpinto 7.2.3 ? </font><br /><font size="2">It gives errors on import, so I cannot try it on 7.2.3.</font><br
/><p><fontsize="2">Hope that helps.</font><p><font size="2">Sebastian Böhm</font><br /><font
size="2">Friendscout24</font><p><fontsize="2">-----Ursprüngliche Nachricht-----</font><br /><font size="2">Von: Tom
Lane[<a href="mailto:tgl@sss.pgh.pa.us">mailto:tgl@sss.pgh.pa.us</a>]</font><br /><font size="2">Gesendet: Mittwoch,
18.Dezember 2002 17:42</font><br /><font size="2">An: "Böhm, Sebastian (Vendor)"</font><br /><font size="2">Cc:
'pgsql-bugs@postgresql.org'</font><br/><font size="2">Betreff: Re: [BUGS] strange problem </font><br /><p><font
size="2">"Böhm,Sebastian (Vendor)" <sebastian.boehm@friendscout24.de> writes:</font><br /><font size="2">>
ici=3D#select id,pseudonym from user_all where pseudonym =3D</font><br /><font size="2">>
'autologin_funkey';</font><br/><font size="2">> id | pseudonym</font><br /><font size="2">>
----+-----------</font><br/><font size="2">> (0 rows)</font><p><font size="2">> ici=3D# select id,pseudonym from
user_allwhere pseudonym ~</font><br /><font size="2">> '^autologin_funkey$';</font><br /><font size="2">> id
| pseudonym</font><br /><font size="2">> ------+------------------</font><br /><font size="2">> 6881 |
autologin_funkey</font><br/><font size="2">> (1 row)</font><p><font size="2">That's pretty bizarre. Can you give a
procedurefor reproducing this</font><br /><font size="2">from a standing start?</font><p> <font
size="2">regards,tom lane</font>