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.
"What we nourish flourishes." - "Was wir nähren erblüht."
In response to
pgsql-admin by date
|Next:||From: Igor Neyman||Date: 2008-07-25 13:13:16|
|Subject: Re: Prent-Child relationships in SQL|
|Previous:||From: Gibson Chimhamhiwa||Date: 2008-07-25 11:42:38|
|Subject: Prent-Child relationships in SQL|