Just a wild guess, but I would imagine
a corrupt (old) index on the userid field would
cause this kind of behavior.
You could test this by dropping the index and
then rebuilding it.
Troy
>
> "pgsql-sql" <pgsql-sql@fc.emc.com.ph> writes:
> > migrate=# select userid from users where userid = 'reynan@yahoo.com';
> > userid
> > ---------------------
> > reynan@yahoo.com
> > admin
> > (2 rows)
>
> That's a tad, um, startling :-(
>
> However, you haven't given us nearly enough information to have a shot
> at figuring out what's going on.
>
> regards, tom lane
>