From: | Phil Sorber <phil(at)omniti(dot)com> |
---|---|
To: | Alejandro Carrillo <fasterzip(at)yahoo(dot)es> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dirtyread doesnt work |
Date: | 2012-12-28 19:11:58 |
Message-ID: | CADAkt-h4Z0sQs7T3wsuRhxKJGOWyp14g7az2nAvd7D0Wi-jSjQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Most likely it's because of TOAST'd records. The module is pretty
naive and needs to be updated to handle such cases.
On Fri, Dec 28, 2012 at 10:53 AM, Alejandro Carrillo <fasterzip(at)yahoo(dot)es> wrote:
>
> 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 | Martin Gainty | 2012-12-28 19:30:31 | Re: OneCNC XR5 3D Mill Expert v30.43 Crack |
Previous Message | terenceng | 2012-12-28 18:43:01 | Re: Installing pgAgent with MS Windows |