Re: 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: Re: pg_dirtyread doesnt work
Date: 2012-12-28 15:53:20
Message-ID: 1356710000.98742.YahooMailNeo@web172205.mail.ir2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Anybody knows why could be happening: ERROR:  invalid memory alloc request size 1850015748

Thanks

>________________________________
> De: Alejandro Carrillo <fasterzip(at)yahoo(dot)es>
>Para: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
>Enviado: Jueves 27 de diciembre de 2012 16:17
>Asunto: [GENERAL] pg_dirtyread doesnt work
>
>
>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
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bryan Lee Nuse 2012-12-28 16:51:38 Re: UNION and pg_restore
Previous Message David Goodenough 2012-12-28 15:31:26 Re: Tool to create database diagrams in postgreSQL