SELECT is returning bogus data.
migrate=# select version();
version
---------------------------------------------------------------
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.3
(1 row)
migrate=# select userid from users where userid = '[EMAIL PROTECTED]';
userid
---------------------
[EMAIL PROTECTED]
admin
(2 rows)
migrate=# \d users
Table "users"
Attribute | Type | Modifier
------------------+--------------+--------------------------------------------------------
userrefkey | integer | not null default
nextval('users_userrefkey_seq'::text)
userid | varchar(128) | not null
password1 | char(20) | not null
password2 | char(50) |
type | char(10) | not null
partneremail | varchar(128) |
adminlastname | char(40) | not null
adminfirstname | char(40) | not null
adminaddress1 | char(80) | not null
adminaddress2 | char(80) |
admincity | char(80) | not null
adminstateprov | char(40) |
admincountrycode | char(2) | not null
adminpostalcode | char(10) |
adminphone | char(20) |
adminfax | char(20) |
checkpayableto | char(80) | not null
createdate | timestamp | not null default now()
lastaccessdate | timestamp |
lastmodifieddate | timestamp |
Indices: users_pkey,
users_userid_key
