Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 5183F5377DB for ; Tue, 29 May 2012 19:17:13 -0300 (ADT) Received: from nm17.bullet.mail.ukl.yahoo.com ([217.146.183.191]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1SZUj0-0007CV-HV for pgsql-performance@postgresql.org; Tue, 29 May 2012 22:17:12 +0000 Received: from [217.146.183.210] by nm17.bullet.mail.ukl.yahoo.com with NNFMP; 29 May 2012 22:16:57 -0000 Received: from [217.146.183.173] by tm3.bullet.mail.ukl.yahoo.com with NNFMP; 29 May 2012 22:16:57 -0000 Received: from [127.0.0.1] by omp1014.mail.ukl.yahoo.com with NNFMP; 29 May 2012 22:16:57 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 307834.78058.bm@omp1014.mail.ukl.yahoo.com Received: (qmail 51454 invoked by uid 60001); 29 May 2012 22:16:57 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.es; s=s1024; t=1338329817; bh=ixCPk0igI4rBmu6Sz6htpyV4jdnhhAFRonTE+vW7cJg=; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=actB2AVpMsZZs5lzhOL9xEmssvq7LvJf4DPpUP74wPR92y1h/LLbg5jsxLFm1JWmb6Mkxm4NoDSVFuZMXuDg3l1qExFOkka1FtFDoMyvwkvraKJs/2QrElNIPJxlFQvg85CbaDZPwZK6uMb0mzVHpTeshfY9DosG5EngseHnmtQ= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.es; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=Ychcm/hRrHDenEjZe5M9XyudzmVBqTM/UJ1XXIwZBPv3ETjWVaGdd6GHma+ueLrC9nYemRihDURFnvIfxhJ3Owhh+n7GqBbZPFWlr/sIvU9qp5sT2SxQMkXh6UjPi51UDZM6KqEIVLmSjt4/qRjh6y62w+kLzHKJU1JFFMbHVzo=; X-YMail-OSG: _2KGsi4VM1mf5l0fcDDEl0TUjHeKT3tuB7aIkR7JTHMgHxK EfzjO3nFCSVFu0nxE2F7k7kPhuKLxR.U8oxQ.MAeyDOvF88O_TUNmJ0DlwYC 7ebJEW3TblX3OfXvfuqQnxTJNwazVITNwpb8lC6i0vse2PbKMoeEcxgeWXZV vgET54mrESwnLmr1M_SmR_whhsPdid_45uokQaUkmIfRg4kB7PPRe.7PJc_i o6PiLynHIjhSsVA_5ORhhtyGCBuTJ7sXMY.WpMNMPH0aP4lCqRUXOksdJo.Y CI9wuTSf0N0AZCvl9xTGCTVV5Hj4Tq1cwrR7u00kjpdkmBoU3nRoPxh_uNfd Wf6djIAU0QfG92H_QdoRiVrFV6ee4mIfMPlRcyKQ9KrRPYGPOVvOI47zhHF8 .bscUcgcNr396qZ8PgevSCw25AeEyXZTeiBct8VR2Gsf3Sape3gkrS7aB2X6 6.EG6tAlCQqUbePojLwMmNuoO2E56 Received: from [190.85.40.123] by web171005.mail.ukl.yahoo.com via HTTP; Tue, 29 May 2012 23:16:56 BST X-Mailer: YahooMailWebService/0.8.118.349524 References: <1338229453.91030.YahooMailNeo@web171005.mail.ukl.yahoo.com> <20120529213320.GA29216@depesz.com> Message-ID: <1338329816.27355.YahooMailNeo@web171005.mail.ukl.yahoo.com> Date: Tue, 29 May 2012 23:16:56 +0100 (BST) From: Alejandro Carrillo Reply-To: Alejandro Carrillo Subject: Re: Recover rows deleted To: "depesz@depesz.com" Cc: "pgsql-performance@postgresql.org" In-Reply-To: <20120529213320.GA29216@depesz.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-126313295-552863009-1338329816=:27355" X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/170 X-Sequence-Number: 46994 ---126313295-552863009-1338329816=:27355 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi friend,=0A=0AYour function doesn't compile in Windows.=0APlease change i= t.=0A=0AThanks=0A=0A=0A=0A=0A>________________________________=0A> De: hube= rt depesz lubaczewski =0A>Para: Alejandro Carrillo =0A>CC: "pgsql-performance@postgresql.org" =0A>Enviado: Martes 29 de Mayo de 2012 16:33=0A>Asunto: = Re: [PERFORM] Recover rows deleted=0A> =0A>On Mon, May 28, 2012 at 07:24:13= PM +0100, Alejandro Carrillo wrote:=0A>> =BFHow I can recover a row delete = of a table that wasn't vacuummed?=0A>> I have PostgreSQL 9.1 in Windows XP/= 7.=0A>=0A>http://www.depesz.com/2012/04/04/lets-talk-dirty/=0A>=0A>Best reg= ards,=0A>=0A>depesz=0A>=0A>-- =0A>The best thing about modern society is ho= w easy it is to avoid contact with it.=0A>=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 http://depesz.com/=0A>=0A>=0A> ---126313295-552863009-1338329816=:27355 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi friend,=

Your function doesn't c= ompile in Windows.
Please change it.

<= div>Thanks

De: hubert depesz lubaczewski <depesz@depesz.com>
Para: Alejandro Carrillo <fasterzip@= yahoo.es>
CC: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>= ;
Enviado: Martes 29 = de Mayo de 2012 16:33
Asunto: Re: [PERFORM] Recover rows deleted

On Mon, M= ay 28, 2012 at 07:24:13PM +0100, Alejandro Carrillo wrote:
> =BFHow I= can recover a row delete of a table that wasn't vacuummed?
> I have = PostgreSQL 9.1 in Windows XP/7.

http://www.depesz.com/2012/04/0= 4/lets-talk-dirty/

Best regards,

depesz

--
The= best thing about modern society is how easy it is to avoid contact with it= .
                    =                      = ;                   http://depesz.com/

---126313295-552863009-1338329816=:27355--