pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to recover deleted data........
2+ messages / 2 participants
[nested] [flat]
* How to recover deleted data........
@ 2008-07-25 11:19 neo3 matrix <neo3matrix@gmail.com>
2008-07-25 11:47 ` Re: How to recover deleted data........ Tino Schwarze <postgresql@tisc.de>
0 siblings, 1 reply; 2+ messages in thread
From: neo3 matrix @ 2008-07-25 11:19 UTC (permalink / raw)
To: 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.............
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to recover deleted data........
2008-07-25 11:19 How to recover deleted data........ neo3 matrix <neo3matrix@gmail.com>
@ 2008-07-25 11:47 ` Tino Schwarze <postgresql@tisc.de>
0 siblings, 0 replies; 2+ messages in thread
From: Tino Schwarze @ 2008-07-25 11:47 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-07-25 11:47 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-07-25 11:19 How to recover deleted data........ neo3 matrix <neo3matrix@gmail.com>
2008-07-25 11:47 ` Tino Schwarze <postgresql@tisc.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox