pg_dirtyread doesnt work - Mailing list pgsql-general

From Alejandro Carrillo
Subject pg_dirtyread doesnt work
Date
Msg-id 1356643049.31168.YahooMailNeo@web172206.mail.ir2.yahoo.com
Whole thread Raw
Responses Re: pg_dirtyread doesnt work  (Alejandro Carrillo <fasterzip@yahoo.es>)
List pgsql-general
Hi,

After of very tried to compile this PostgreSQL C function for Windows, I compile that (with VS C++ 2008), but the function get a error when try to read a deleted row. The example:

CREATE FUNCTION pg_dirtyread(oid)
RETURNS setof record
AS E'$libdir/pg_dirtyread', 'pg_finfo_pg_dirtyread' LANGUAGE C STRICT ;

Create table hola(
id bigserial,
dato1 varchar(199) not null,
fecha date
);

/*insert 3 rows and delete 1 row*/


select * from pg_dirtyread('hola'::regclass) t (id bigint,dato1 varchar(199), fecha date);

ERROR:  invalid memory alloc request size 1850015748

Anybody can help me?

Thanks

pgsql-general by date:

Previous
From: Mark Morgan Lloyd
Date:
Subject: Re: libpq thread safety
Next
From: Kirk Wythers
Date:
Subject: update from a csv file?