Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 16109C955BB for ; Mon, 4 Jun 2012 13:47:24 -0300 (ADT) Received: from nm19-vm0.bullet.mail.ukl.yahoo.com ([217.146.183.113]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1SbaR9-0007ve-Eb for pgsql-performance@postgresql.org; Mon, 04 Jun 2012 16:47:24 +0000 Received: from [217.146.183.183] by nm19.bullet.mail.ukl.yahoo.com with NNFMP; 04 Jun 2012 16:47:10 -0000 Received: from [217.146.182.76] by tm14.bullet.mail.ukl.yahoo.com with NNFMP; 04 Jun 2012 16:47:10 -0000 Received: from [127.0.0.1] by omp1040.mail.ukl.yahoo.com with NNFMP; 04 Jun 2012 16:47:10 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 262050.16689.bm@omp1040.mail.ukl.yahoo.com Received: (qmail 45376 invoked by uid 60001); 4 Jun 2012 16:47:10 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.es; s=s1024; t=1338828430; bh=ckUQXsStTOZw5NFDykR+745NraLlC/0VteqllsQSZ/c=; 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=lCbAn5M3G0zgu11aLjsBzNMF7Lvx8RfzHtlCoC2lvUnQ1v6YiZTeDMZtm0dMO217tscW+x61dj3tqEbgXdZhetE2/D+XbJGM7MAHkaOreobQN+qQZGDrcRrvp8Kn2UUEC01GAnYhlRvbOu0AIK5G+qC68tq0J52b2hVLWXZLSh8= 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=HJorgkxEUNGd3/RF9dLZQT0VNKZPgzsbFMqllQGcD7YfZ/eWReZ9h1DwMSg6vnFd8WhcGmeq6AL7zfXXxd4/c++5UbWT/IV83/i6V2J9ChU2/wFpDLc8wM0rLeR0Igpvn0mGRo5pPKkGv1AsqjVaEtDGwkK7JaKR6GwTjLDdrFU=; X-YMail-OSG: fKMgv4gVM1nfvgQYe7sfCrqdwcNlnaArRZchDZ7W7p7dtt4 1BNOfQYTYeNQMwVXauEDTeq6rl00rJezBGQymKVaPu4N71Jd4NBmGcpWJx78 8kuVYBVbIy7ddxZ8nsl8TF.swqDsbmDvLCDKzLWuJHK6kHBx8Ze6kAe2t7b6 LZkKKG.D.8K.RT186wmp_xylboAGHRerz.kJABAB5Du7wj.L_.PUC9le_om9 Xw_TvaRRWTE2EpQ977x7RetkG50XjRz9LyZ17.BsA3w95x7AoVB3OdJPjqNt zPZbxxihz1skC7VOay02Q5yLeeR5tH_NyQuTceXFGQdRtxDGfn5XSrjEeU54 R5TGCoxWteOvsVN7ZElAKl4KTtmH4VUh7YuCOssvbz1yGVwCH9mtsyS8rsNO _xo0x_DP1ruhqgIARBB3K.SDm4IM04h7D7yUpBelARRu0yynmmMk.jLIhg7C u_0WDLlJ5rjlaT8otTxb6N6OPUI7FCapAoqtPiVz7VHdygAeJ7hwQu.2sVFL z.88FxqhtfvB4JBgR1iCugx75J1BjSx3ZBgQMVFm7zyw6YzKNdY.Qm1jekyJ 9ljFmPmQ73uwxbhGgu8cm7ApuQRBIK6RMdpLDYWyY3FJ2rQt1Ojm0qB9S628 oUrsR574Trw-- Received: from [190.85.40.123] by web171006.mail.ukl.yahoo.com via HTTP; Mon, 04 Jun 2012 17:47:10 BST X-Mailer: YahooMailWebService/0.8.118.349524 References: <1338229453.91030.YahooMailNeo@web171005.mail.ukl.yahoo.com> <1338324800.28651.5.camel@sussancws0025> <1338826451.78107.YahooMailNeo@web171001.mail.ukl.yahoo.com> <4FCCE5A4.8040001@optionshouse.com> Message-ID: <1338828430.37350.YahooMailNeo@web171006.mail.ukl.yahoo.com> Date: Mon, 4 Jun 2012 17:47:10 +0100 (BST) From: Alejandro Carrillo Reply-To: Alejandro Carrillo Subject: Re: Recover rows deleted To: "sthomas@optionshouse.com" Cc: "pgsql-performance@postgresql.org" In-Reply-To: <4FCCE5A4.8040001@optionshouse.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="2073204126-987402338-1338828430=:37350" X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/11 X-Sequence-Number: 47037 --2073204126-987402338-1338828430=:37350 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable In linux exists (https://github.com/omniti-labs/pgtreats/blob/master/contri= b/pg_dirtyread/pg_dirtyread.c)=0ABut I can't compile in Windows :(=0AAnybod= y could compile in Windows?=0A=0A=0A=0A=0A>________________________________= =0A> De: Shaun Thomas =0A>Para: Alejandro Carrill= o =0A>CC: "pgsql-performance@postgresql.org" =0A>Enviado: Lunes 4 de junio de 2012 11:43=0A>As= unto: Re: [PERFORM] Recover rows deleted=0A> =0A>On 06/04/2012 11:14 AM, Al= ejandro Carrillo wrote:=0A>=0A>> Anybody knows a function that let's recove= r a record (row) deleted in=0A>> Windows?=0A>=0A>Sorry Alejandro, I'm prett= y sure no database anywhere has a function like that. If there were, I'd ce= rtainly like to see it! Generally you avoid situations like this by using t= ransactions. If you do accidentally delete a row, that's what backups are f= or.=0A>=0A>Again, sorry to be the bearer of bad news.=0A>=0A>-- Shaun Thoma= s=0A>OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604=0A= >312-444-8534=0A>sthomas@optionshouse.com=0A>=0A>__________________________= ____________________=0A>=0A>See http://www.peak6.com/email_disclaimer/ for = terms and conditions related to this email=0A>=0A>-- Sent via pgsql-perform= ance mailing list (pgsql-performance@postgresql.org)=0A>To make changes to = your subscription:=0A>http://www.postgresql.org/mailpref/pgsql-performance= =0A>=0A>=0A> --2073204126-987402338-1338828430=:37350 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
In linux e= xists (https://github.com/omniti-labs/pgtreats/blob/master/contrib/pg_dirty= read/pg_dirtyread.c)
But I can't compile in Windows = :(
Anybody could compile in Windows?

<= span style=3D"font-weight:bold;">De: Shaun Thomas <sthomas@op= tionshouse.com>
Para: Alejandro Carrillo <fasterzip@yahoo.es>
CC: "pgsql-performance@postgresql.org" <pgsql-perform= ance@postgresql.org>
Enviado:= Lunes 4 de junio de 2012 11:43
Asunto: Re: [PERFORM] Recover rows deleted
=

On 06/04/2012 11:14 AM, Alejandro Carrillo wrote:

> A= nybody 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! General= ly you avoid situations like this by using transactions. If you do accident= ally delete a row, that's what backups are for.

Again, sorry to be t= he bearer of bad news.

-- Shaun Thomas
OptionsHouse | 141 W. Jack= son Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com
<= br>______________________________________________

See http://www.peak6.com= /email_disclaimer/ for terms and conditions related to this email
-- Sent via pgsql-performance mailing list (= pgsql-performance@postgresql.org)
To make changes to your subscripti= on:
http://www.postgresql.org/mailpref/pgsql-performance
=

--2073204126-987402338-1338828430=:37350--