How to recover deleted data........

From: "neo3 matrix" <neo3matrix(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to recover deleted data........
Date: 2008-07-25 11:19:48
Message-ID: 4b393c0d0807250419j6e337e8dk9c420003be63d03@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello friends!
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 ...............
how to recover it?
reply soon...............
thanks in advance.............

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gibson Chimhamhiwa 2008-07-25 11:42:38 Prent-Child relationships in SQL
Previous Message Scott Marlowe 2008-07-24 20:13:24 Re: Upgrade clients when (major) upgrading server?