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

Re: Missing row after update

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Dinsdale <russ(dot)haley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Missing row after update
Date: 2012-06-07 17:44:46
Message-ID: 4FD0E88E.2030106@gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On 06/07/2012 06:57 AM, Dinsdale wrote:
 > 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)%';

So just to be clear the above was what was run multiple times?

 >
 > I cannot find the record at all so tried to re-insert it and the query
 > just runs and runs and runs.

Select * from jaas_login where login_name like CompanyAdmin(at)%'; shows 
nothing?

What is your INSERT query?
 >
 > 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.

I tend to doubt it just disappeared.
 >
 > Any help would really save my butt. Thanks
 >
 > Dinsdale
 >



-- 
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

pgsql-general by date

Next:From: Steve CrawfordDate: 2012-06-07 17:47:04
Subject: Re: Missing row after update
Previous:From: Raymond O'DonnellDate: 2012-06-07 17:07:55
Subject: Re: Two databases on the same server, looking for idea how to restrict access.

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