From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Missing row after update |
Date: | 2012-06-07 17:47:04 |
Message-ID: | 4FD0E918.5000209@pinpointresearch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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)%';
>
> I cannot find the record at all so tried to re-insert it and the query
> just runs and runs and runs.
>
8.4.what? Perhaps you encountered this:
http://www.databasesoup.com/2012/03/postgres-update-release-data-loss-and.html
Does reindexing that table help?
Cheers,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Dinsdale | 2012-06-07 18:23:40 | Re: Missing row after update |
Previous Message | Adrian Klaver | 2012-06-07 17:44:46 | Re: Missing row after update |