Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id C3E6FC955BB for ; Mon, 4 Jun 2012 14:46:37 -0300 (ADT) Received: from nm1.bullet.mail.ukl.yahoo.com ([217.146.183.218]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1SbbMQ-0000OP-TB for pgsql-performance@postgresql.org; Mon, 04 Jun 2012 17:46:37 +0000 Received: from [217.146.183.180] by nm1.bullet.mail.ukl.yahoo.com with NNFMP; 04 Jun 2012 17:46:21 -0000 Received: from [217.146.183.40] by tm11.bullet.mail.ukl.yahoo.com with NNFMP; 04 Jun 2012 17:46:21 -0000 Received: from [127.0.0.1] by omp1025.mail.ukl.yahoo.com with NNFMP; 04 Jun 2012 17:46:21 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 671239.47766.bm@omp1025.mail.ukl.yahoo.com Received: (qmail 88017 invoked by uid 60001); 4 Jun 2012 17:46:21 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.es; s=s1024; t=1338831981; bh=UjNDrTRq8L9DiK9r976GbIagoXjk9qG2YcX8zFDtKSw=; 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=dP+iNH261AZzJKwLqw2L/UAJTIqXbEQapw8o/GMFSgoYiuJV0uvsM0NjjT4BM82UahEsySSvxisxlO4trpyzWBLpvcgHpO8VWO0DVEbVdh+XWtZrLu+J85gJTeg2dtynKAE3MFBpzG2ZUiDf0YeUX4MQ9e+YIz8NyDWejves4PY= 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=jllhdenLEFTWsnc7iNKZ5R7VXOet0Efx1OEtitZFcWqaZIVfActW6zbOFybSMoYAFDV4cH4eYfgLqS9mBquDUDVl1dTLZOs6S96J1jIbU8WYM6sUfBHEBNXuGCgR2Fqjs0K6d4aFFWZALFUeLpURdSmEtfuD9gzSUYE8VrXcPrM=; X-YMail-OSG: 3U4RyZcVM1nGlzQYDXL.e9PPAGrDno9OpjmHHTFuGc2hxil NtlSq9VVs_6K7RC56I9iXFkGI8SuuFyHIBoqA73fVYAcHDd8fjpJD5nSWIpS GG_7.PEjqtYdHTvuX4FVkqbDd1L744nI7g2W8UlAWw1IScqRGjREQqTPnE8u AEomWZLxIjqUvKtmgHpgKT6odXGrjTuCF0YMdjU8NAeg8LiU0INtk2HyqZv7 mT9ZMhgpiIoYRMYmaVi7XQWz.vdQAzgtwrUQA8xb.C1fJAv.zmDBDXK8czJ8 IPBxmcQdz959.s7VPjsntsQAlE6YeOrwODsPJynrYs3x65lxmzs4mjgPqlNf AuxlQGVZOUFX7nPtrhI8dgBgtHh9v9066vXmzVBfgdIezVwjclN8MWMlkTVO a_nJYY.oOgtd735nzmIMSSOuDEn3tqd718HZlAc3oBphdoVXq4FVLZEzMJAJ MFXK71aE_jndeXHRinhS4FXCp9vK7Mgy2zylFSgz6.GeSuIIlGmSz6tT8awm tTkXP9OJfD3LhaRxkSGHOXhCtJfC_nIZ4wSTcZrWaLlIifFc1MuN1e8vWcEy tBWbLEZ6JPweGC4krwcGYJ_9Cu1RGHhO.19J.A86Ez8jN6duh4QDzo4rz7Pi 4clNYPAaEMGzsPMvoKW3dzTtlh1A0wbeWte9E4T6MOaAw2ohiG_VwUPlFkPo - Received: from [190.85.40.123] by web171002.mail.ukl.yahoo.com via HTTP; Mon, 04 Jun 2012 18:46:21 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> <1338828430.37350.YahooMailNeo@web171006.mail.ukl.yahoo.com> Message-ID: <1338831981.68692.YahooMailNeo@web171002.mail.ukl.yahoo.com> Date: Mon, 4 Jun 2012 18:46:21 +0100 (BST) From: Alejandro Carrillo Reply-To: Alejandro Carrillo Subject: Re: Recover rows deleted To: Merlin Moncure Cc: "sthomas@optionshouse.com" , "pgsql-performance@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1538572512-1889957640-1338831981=:68692" X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/13 X-Sequence-Number: 47039 --1538572512-1889957640-1338831981=:68692 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable How I can compile in Windows? I tried to compile using Dev-C++ 4.9 and show= a warning:=0ACompilador: Default compiler=0ABuilding Makefile: "C:\Documen= ts and Settings\Administrador\Escritorio\pg_dirtyread\Makefile.win"=0AEjecu= tando=A0 make clean=0Arm -f pg_dirtyread.o=A0 pg_dirtyread.a=0A=0Agcc.exe -= c pg_dirtyread.c -o pg_dirtyread.o -I"C:/Dev-Cpp/include"=A0 -I"C:/postgres= ql-9.1.0-1-windows-binaries listo/pgsql/include/server"=A0 -I"C:/postgresql= -9.1.0-1-windows-binaries listo/pgsql/include/libpq"=A0 -I"C:/postgresql-9.= 1.0-1-windows-binaries listo/pgsql/include"=A0 -I"C:/postgresql-9.1.0-1-win= dows-binaries listo/pgsql/include/server/port/win32"=A0 -DBUILDING_DLL=3D1= =A0=A0 -DHAVE_LONG_INT_64=3D1=0A=0AIn file included from C:/postgresql-9.1.= 0-1-windows-binaries listo/pgsql/include/server/c.h:851,=0A=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 from C:/postgresql-9.1.0-1-windows-binari= es listo/pgsql/include/server/postgres.h:47,=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 from pg_dirtyread.c:34:=0AC:/postgresql-9.1.0-1-windo= ws-binaries listo/pgsql/include/server/port.h:191: warning: `gnu_printf' is= an unrecognized format function type=0AC:/postgresql-9.1.0-1-windows-binar= ies listo/pgsql/include/server/port.h:195: warning: `gnu_printf' is an unre= cognized format function type=0AC:/postgresql-9.1.0-1-windows-binaries list= o/pgsql/include/server/port.h:200: warning: `gnu_printf' is an unrecognized= format function type=0AC:/postgresql-9.1.0-1-windows-binaries listo/pgsql/= include/server/port.h:204: warning: `gnu_printf' is an unrecognized format = function type=0A=0AIn file included from C:/postgresql-9.1.0-1-windows-bina= ries listo/pgsql/include/server/postgres.h:48,=0A=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 from pg_dirtyread.c:34:=0AC:/postgresql-9.1.0-1-wi= ndows-binaries listo/pgsql/include/server/utils/elog.h:127: warning: `gnu_p= rintf' is an unrecognized format function type=0AC:/postgresql-9.1.0-1-wind= ows-binaries listo/pgsql/include/server/utils/elog.h:133: warning: `gnu_pri= ntf' is an unrecognized format function type=0AC:/postgresql-9.1.0-1-window= s-binaries listo/pgsql/include/server/utils/elog.h:141: warning: `gnu_print= f' is an unrecognized format function type=0AC:/postgresql-9.1.0-1-windows-= binaries listo/pgsql/include/server/utils/elog.h:141: warning: `gnu_printf'= is an unrecognized format function type=0AC:/postgresql-9.1.0-1-windows-bi= naries listo/pgsql/include/server/utils/elog.h:147: warning: `gnu_printf' i= s an unrecognized format function type=0AC:/postgresql-9.1.0-1-windows-bina= ries listo/pgsql/include/server/utils/elog.h:153: warning: `gnu_printf' is = an unrecognized format function type=0AC:/postgresql-9.1.0-1-windows-binari= es listo/pgsql/include/server/utils/elog.h:159: warning: `gnu_printf' is an= unrecognized format function type=0AC:/postgresql-9.1.0-1-windows-binaries= listo/pgsql/include/server/utils/elog.h:167: warning: `gnu_printf' is an u= nrecognized format function type=0AC:/postgresql-9.1.0-1-windows-binaries l= isto/pgsql/include/server/utils/elog.h:167: warning: `gnu_printf' is an unr= ecognized format function type=0AC:/postgresql-9.1.0-1-windows-binaries lis= to/pgsql/include/server/utils/elog.h:173: warning: `gnu_printf' is an unrec= ognized format function type=0A=0AC:/postgresql-9.1.0-1-windows-binaries li= sto/pgsql/include/server/utils/elog.h:179: warning: `gnu_printf' is an unre= cognized format function type=0AC:/postgresql-9.1.0-1-windows-binaries list= o/pgsql/include/server/utils/elog.h:206: warning: `gnu_printf' is an unreco= gnized format function type=0AC:/postgresql-9.1.0-1-windows-binaries listo/= pgsql/include/server/utils/elog.h:216: warning: `gnu_printf' is an unrecogn= ized format function type=0AC:/postgresql-9.1.0-1-windows-binaries listo/pg= sql/include/server/utils/elog.h:375: warning: `gnu_printf' is an unrecogniz= ed format function type=0A=0AIn file included from C:/postgresql-9.1.0-1-wi= ndows-binaries listo/pgsql/include/server/access/xlog.h:16,=0A=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 from C:/postgresql-9.1.0-1-windows-bin= aries listo/pgsql/include/server/access/heapam.h:20,=0A=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 from C:/postgresql-9.1.0-1-windows-binaries = listo/pgsql/include/server/nodes/execnodes.h:18,=0A=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 from C:/postgresql-9.1.0-1-windows-binaries listo/= pgsql/include/server/executor/execdesc.h:18,=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 from C:/postgresql-9.1.0-1-windows-binaries listo/pgs= ql/include/server/executor/executor.h:17,=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/= include/server/funcapi.h:21,=0A=0A=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 from pg_dirtyread.c:35:=0AC:/postgresql-9.1.0-1-windows-binaries = listo/pgsql/include/server/lib/stringinfo.h:98: warning: `gnu_printf' is an= unrecognized format function type=0A=0Aar r pg_dirtyread.a pg_dirtyread.o = =0A=0Aar: creating pg_dirtyread.a=0A=0Aranlib pg_dirtyread.a=0A=0AEjecuci= =F3n Terminada=0A=0AI use the sources of binary downloaded of http://www.en= terprisedb.com/products-services-training/pgbindownload.=0A=0AWhat I doing = bad?=0A=0AThanks=0A=0A=0A=0A=0A=0A>________________________________=0A> De:= Merlin Moncure =0A>Para: Alejandro Carrillo =0A>CC: "sthomas@optionshouse.com" ; "= pgsql-performance@postgresql.org" =0A>En= viado: Lunes 4 de junio de 2012 12:04=0A>Asunto: Re: [PERFORM] Recover rows= deleted=0A> =0A>On Mon, Jun 4, 2012 at 11:47 AM, Alejandro Carrillo wrote:=0A>> In linux exists=0A>> (https://github.com/omniti-= labs/pgtreats/blob/master/contrib/pg_dirtyread/pg_dirtyread.c)=0A>> But I c= an't compile in Windows :(=0A>> Anybody could compile in Windows?=0A>=0A>= =0A>There are no linux specific calls in there that I can see-- it should= =0A>be a matter of compiling and installing it.=A0 Do you have a compiler?= =0A>What issues are you having with compiling?=A0 It might just be a matte= r=0A>of setting up postgres build environment.=0A>=0A>merlin=0A>=0A>-- =0A>= Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)= =0A>To make changes to your subscription:=0A>http://www.postgresql.org/mail= pref/pgsql-performance=0A>=0A>=0A> --1538572512-1889957640-1338831981=:68692 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
How I can = compile in Windows? I tried to compile using Dev-C++ 4.9 and show a warning= :
Compilador: Default compiler
Building Makefile:= "C:\Documents and Settings\Administrador\Escritorio\pg_dirtyread\Makefile.= win"
Ejecutando  make clean
rm -f pg_dirtyread.o  pg_dirtyr= ead.a

gcc.exe -c pg_dirtyread.c -o pg_dirtyread.o -I"C:/Dev-Cpp/incl= ude"  -I"C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/se= rver"  -I"C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/l= ibpq"  -I"C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include"&= nbsp; -I"C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/= port/win32"  -DBUILDING_DLL=3D1   -DHAVE_LONG_INT_64=3D1
=
In file included from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/c.h:851,
      = ;           from C:/postg= resql-9.1.0-1-windows-binaries listo/pgsql/include/server/postgres.h:47,            &n= bsp;    from pg_dirtyread.c:34:
C:/postgresql-9.1.0-1-win= dows-binaries listo/pgsql/include/server/port.h:191: warning: `gnu_printf' = is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-bi= naries listo/pgsql/include/server/port.h:195: warning: `gnu_printf' is an u= nrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries = listo/pgsql/include/server/port.h:200: warning: `gnu_printf' is an unrecogn= ized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/p= gsql/include/server/port.h:204: warning: `gnu_printf' is an unrecognized fo= rmat function type

In file included from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/postgres= .h:48,
           = ;      from pg_dirtyread.c:34:
C:/postgresql-9.= 1.0-1-windows-binaries listo/pgsql/include/server/utils/elog.h:127: warning= : `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1= .0-1-windows-binaries listo/pgsql/include/server/utils/elog.h:133: warning:= `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.= 0-1-windows-binaries listo/pgsql/include/server/utils/elog.h:141: warning: = `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0= -1-windows-binaries listo/pgsql/include/server/utils/elog.h:141: warning: `= gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-= 1-windows-binaries listo/pgsql/include/server/utils/elog.h:147: warning: `g= nu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/= utils/elog.h:153: warning: `gnu_printf' is an unrecognized format function = type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/u= tils/elog.h:159: warning: `gnu_printf' is an unrecognized format function t= ype
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/ut= ils/elog.h:167: warning: `gnu_printf' is an unrecognized format function ty= pe
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/uti= ls/elog.h:167: warning: `gnu_printf' is an unrecognized format function typ= e
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/util= s/elog.h:173: warning: `gnu_printf' is an unrecognized format function type=

C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/u= tils/elog.h:179: warning: `gnu_printf' is an unrecognized format function t= ype
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/utils/elog.h:206: warning: `gnu_printf' is an u= nrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries = listo/pgsql/include/server/utils/elog.h:216: warning: `gnu_printf' is an un= recognized format function type
C:/postgresql-9.1.0-1-windows-binaries l= isto/pgsql/include/server/utils/elog.h:375: warning: `gnu_printf' is an unr= ecognized format function type

In file included from C:/postgresql-9= .1.0-1-windows-binaries listo/pgsql/include/server/access/xlog.h:16,
&nb= sp;            =     from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/= include/server/access/heapam.h:20,
      &= nbsp;          from C:/postgre= sql-9.1.0-1-windows-binaries listo/pgsql/include/server/nodes/execnodes.h:18,
   &nbs= p;             = from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/exec= utor/execdesc.h:18,
        &nbs= p;        from C:/postgresql-9.1.0-1-win= dows-binaries listo/pgsql/include/server/executor/executor.h:17,
 &= nbsp;           &nbs= p;   from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/incl= ude/server/funcapi.h:21,

       &= nbsp;         from pg_dirtyread.c:3= 5:
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/lib= /stringinfo.h:98: warning: `gnu_printf' is an unrecognized format function = type

ar r pg_dirtyread.a pg_dirtyread.o

ar: creating pg_dirtyread.a

ranlib pg_dirtyread.a

Ejecuci=F3n Terminada

I use the sources of bina= ry downloaded of http://www.enterprisedb.com/products-services-training/pgb= indownload.

What I doing= bad?

Thanks
<= /div>


De: Merlin Moncure <mmoncure@gmail.com>
Para: Alejandro Carrillo <fasterzip@yahoo.es&g= t;
CC: "sthomas@optionsh= ouse.com" <sthomas@optionshouse.com>; "pgsql-performance@postgresql.o= rg" <pgsql-performance@postgresql.org>
Enviado: Lunes 4 de junio de 2012 12:04
Asunto: Re: [PERFORM] Recover row= s deleted

On Mon, Jun 4, 2012 at 11:47 AM, Alejandro= Carrillo <fasterzip@yahoo.es> wrote:
> In linux exists> (https://github.com/omniti= -labs/pgtreats/blob/master/contrib/pg_dirtyread/pg_dirtyread.c)
>= But I can't compile in Windows :(
> Anybody could compile in Windows= ?


There are no linux specific calls in there that I can see-- it should
be a matter of compiling and installing it.  Do you have a= compiler?
What issues are you having with compiling?  It might ju= st be a matter
of setting up postgres build environment.

merlin
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your su= bscription:
http://www.postgresql.org/mailpref/pgsql-performance=


--1538572512-1889957640-1338831981=:68692--