From: | Dinsdale <russ(dot)haley(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Missing row after update |
Date: | 2012-06-07 13:57:12 |
Message-ID: | 76f9f335-4465-44cc-8b83-2980ba2f9319@3g2000vbx.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi there. I am new to Postgresql but very familiar with RDBMS. We are
running 8.4 on windows serer 2008 r2. I was updating a record through
pgAdmin and was being an a$$ and pressed the run button multiple times
and then the record just disappeared. Update query:
update jaas_login set password=md5(login_name || ':' || realm_name ||
':Password123'), has_logged_in = false, modified=now(),
failed_attempts=0 where login_name like 'CompanyAdmin(at)%';
I cannot find the record at all so tried to re-insert it and the query
just runs and runs and runs.
We thought we had backups of this DB but all we have are dump files
and I really really don't want to have to restore if I can avoid it. I
find it hard to believe that a db as advanced as postgresql will just
"lose" data and there has to be some explaination for where the record
is.
Any help would really save my butt. Thanks
Dinsdale
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Watson | 2012-06-07 14:00:00 | Postgres 9.2 beta2 one-click installer on windows |
Previous Message | Ben Carbery | 2012-06-07 09:02:21 | Re: Partitioning Advice |