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

Re: How to recover deleted data........

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to recover deleted data........
Date: 2008-07-25 11:47:28
Message-ID: 20080725114728.GC6464@easy2.in-chemnitz.de (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, Jul 25, 2008 at 04:49:48PM +0530, neo3 matrix wrote:

> I have a table property_details having columns (mid,pid,pv,vt)
> Accidentally , i fired a query
> delete from property_details where mid=27617 and pid=20 or pid=21 or pid=22
> , which resulted in deletion of 418 rows which had pids 21 and 22 , which i
> don't want.......
> So , plz can anyone help me out to recover all those rows having pid=21 and
> pid=22 ...............

If you did that without a transaction, things might become very
complicated to restore and might require lots of fiddling. 

The easiest way is to restore from backup.

Tino.

-- 
"What we nourish flourishes." - "Was wir nähren erblüht."

www.craniosacralzentrum.de
www.forteego.de

In response to

pgsql-admin by date

Next:From: Igor NeymanDate: 2008-07-25 13:13:16
Subject: Re: Prent-Child relationships in SQL
Previous:From: Gibson ChimhamhiwaDate: 2008-07-25 11:42:38
Subject: Prent-Child relationships in SQL

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