Skip site navigation (1) Skip section navigation (2)

Re: strange problem

From: "Böhm, Sebastian (Vendor)" <sebastian(dot)boehm(at)friendscout24(dot)de>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: strange problem
Date: 2002-12-18 18:31:05
Message-ID: F11E485B8CEDD5119AAA000102F4030E2DBCE8@esdeklnbdcxc.internal.friendscout24.de (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-12-18 19:17:47
Subject: Re: strange problem
Previous:From: Tom LaneDate: 2002-12-18 16:42:14
Subject: Re: strange problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group