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
>
>
>
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 |