Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 28BA8C955BB for ; Mon, 4 Jun 2012 13:43:30 -0300 (ADT) Received: from smtp2.peak6.com ([38.98.137.9]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SbaNN-0007pt-Uz for pgsql-performance@postgresql.org; Mon, 04 Jun 2012 16:43:30 +0000 X-AuditID: 0a02cb1e-b7fa76d000000a63-34-4fcce596bbba Message-ID: <4FCCE5A4.8040001@optionshouse.com> Date: Mon, 4 Jun 2012 11:43:16 -0500 From: Shaun Thomas Reply-To: Organization: Peak6 User-Agent: Mozilla/5.0 (X11; Linux i686; rv:12.0) Gecko/20120430 Thunderbird/12.0.1 MIME-Version: 1.0 To: Alejandro Carrillo CC: "pgsql-performance@postgresql.org" Subject: Re: Recover rows deleted References: <1338229453.91030.YahooMailNeo@web171005.mail.ukl.yahoo.com> <1338324800.28651.5.camel@sussancws0025> <1338826451.78107.YahooMailNeo@web171001.mail.ukl.yahoo.com> In-Reply-To: <1338826451.78107.YahooMailNeo@web171001.mail.ukl.yahoo.com> Content-Type: text/plain; charset="ISO-8859-1"; format=flowed content-transfer-encoding: 7bit X-Originating-IP: [10.10.201.64] X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFrrPIsWRmVeSWpSXmKPExsXClcIrpjvt6Rl/gydnZS22rNG2uD7zHLMD k8eFfdPYPV4decQawBTVwGiTmJeXX5JYkqqQklqcbKvkX1CSmZ9X7JFfWpyq4JJZnJyTmJmb WqSkkJliq2SupFCQk5icmpuaV2KrlFhQkJqXomTHpYABbIDKMvMUUvOS81My89JtlTyD/XUt LEwtdQ2V7OKRQUInS8a5Y1OZCw6xVJx9sIytgfEscxcjJ4eEgInEr7uT2CBsMYkL99aD2bwC +hL357wBq2ERUJGY9us4mM0moCsxqX8FWI0QULzv7A0mEJtfQFhi34cmsBpRgRCJc0++Q80R lDg58wkLiC0ioC3x5uQMVhCbWcBTouPUKkYQWxgofmXxSqA4F9DMdYwS2zY/YQdJcAIVnZy7 lgWiwVbiwpzrULa8xPa3c5ghjlCVWNE8EeoBBYn/V94xTWAUmoVk9ywk7bOQtC9gZF7FKF5c lpickWlWUJxbUmCoV5CamG2ml5dasokRFLlMp+V2MK64oHiIUYCDUYmHt+DsGX8h1sSy4src Q4wSHMxKIrxPJgKFeFMSK6tSi/Lji0pzUosPMZoCA20is5Rocj4wqeSVxBsaG1qaWpqYWZob GxsoifN+XwvUJJAOTA/ZqakFqUUwfUwcnFINjBtD991V/tcY3v7PPKvyxdqcGVuitfqXbFNk 9RYUNROufu9j31d8VG53XIxRmHMgh41iaJfRXhuh9R/0/k+T23zvc9mL+4vdpDu/rX76hPtb t9frAC4n/j2TbQwLdfauv/GL6Zir4oOg+68vhpu5TfjwbsGWVF8e9flTH5hNfvpY3yVjWvqt KUosxRmJhlrMRcWJAFlW7PDyAgAA X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/10 X-Sequence-Number: 47036 On 06/04/2012 11:14 AM, Alejandro Carrillo wrote: > Anybody knows a function that let's recover a record (row) deleted in > Windows? Sorry Alejandro, I'm pretty sure no database anywhere has a function like that. If there were, I'd certainly like to see it! Generally you avoid situations like this by using transactions. If you do accidentally delete a row, that's what backups are for. Again, sorry to be the bearer of bad news. -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-444-8534 sthomas@optionshouse.com ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email