pg_dirtyread doesnt work

From: Alejandro Carrillo <fasterzip(at)yahoo(dot)es>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pg_dirtyread doesnt work
Date: 2012-12-27 21:17:29
Message-ID: 1356643049.31168.YahooMailNeo@web172206.mail.ir2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-12-28 05:18:37 Re: update table from csv file
Previous Message Mark Morgan Lloyd 2012-12-27 20:19:46 Re: libpq thread safety