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 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
