From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: How to recover deleted data........
Date: Fri, 25 Jul 2008 13:47:28 +0200
Message-ID: <20080725114728.GC6464@easy2.in-chemnitz.de> (raw)
In-Reply-To: <4b393c0d0807250419j6e337e8dk9c420003be63d03@mail.gmail.com>
References: <4b393c0d0807250419j6e337e8dk9c420003be63d03@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: postgresql@tisc.de
Subject: Re: How to recover deleted data........
In-Reply-To: <20080725114728.GC6464@easy2.in-chemnitz.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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