From: Alejandro Carrillo <fasterzip@yahoo.es>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: sthomas@optionshouse.com <sthomas@optionshouse.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Recover rows deleted
Date: Mon, 4 Jun 2012 18:46:21 +0100 (BST)
Message-ID: <1338831981.68692.YahooMailNeo@web171002.mail.ukl.yahoo.com> (raw)
In-Reply-To: <CAHyXU0x3GFZjV-rwd+MKG0mqP8-PzBfqwQMhafv5-s8yaaNHpA@mail.gmail.com>
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>
<CAHyXU0x3GFZjV-rwd+MKG0mqP8-PzBfqwQMhafv5-s8yaaNHpA@mail.gmail.com>
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_dirtyread.a
gcc.exe -c pg_dirtyread.c -o pg_dirtyread.o -I"C:/Dev-Cpp/include" -I"C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server" -I"C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/libpq" -I"C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include" -I"C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/port/win32" -DBUILDING_DLL=1 -DHAVE_LONG_INT_64=1
In file included from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/c.h:851,
from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/postgres.h:47,
from pg_dirtyread.c:34:
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/port.h:191: warning: `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/port.h:195: warning: `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/port.h:200: warning: `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/port.h:204: warning: `gnu_printf' is an unrecognized format 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: `gnu_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/utils/elog.h:159: warning: `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/utils/elog.h:167: warning: `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/utils/elog.h:167: warning: `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/utils/elog.h:173: warning: `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/utils/elog.h:179: warning: `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/utils/elog.h:206: warning: `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/utils/elog.h:216: warning: `gnu_printf' is an unrecognized format function type
C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/utils/elog.h:375: warning: `gnu_printf' is an unrecognized format function type
In file included from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/access/xlog.h:16,
from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/access/heapam.h:20,
from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/nodes/execnodes.h:18,
from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/executor/execdesc.h:18,
from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/executor/executor.h:17,
from C:/postgresql-9.1.0-1-windows-binaries listo/pgsql/include/server/funcapi.h:21,
from pg_dirtyread.c:35:
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ón Terminada
I use the sources of binary downloaded of http://www.enterprisedb.com/products-services-training/pgbindownload.
What I doing bad?
Thanks
>________________________________
> De: Merlin Moncure <mmoncure@gmail.com>
>Para: Alejandro Carrillo <fasterzip@yahoo.es>
>CC: "sthomas@optionshouse.com" <sthomas@optionshouse.com>; "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
>Enviado: Lunes 4 de junio de 2012 12:04
>Asunto: Re: [PERFORM] Recover rows 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 just 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 subscription:
>http://www.postgresql.org/mailpref/pgsql-performance
>
>
>
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-performance@postgresql.org
Cc: fasterzip@yahoo.es, mmoncure@gmail.com, sthomas@optionshouse.com
Subject: Re: Recover rows deleted
In-Reply-To: <1338831981.68692.YahooMailNeo@web171002.mail.ukl.yahoo.com>
* 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