Re: pg_dirtyread doesnt work - Mailing list pgsql-general

From Alejandro Carrillo
Subject Re: pg_dirtyread doesnt work
Date
Msg-id 1356726708.78061.YahooMailNeo@web172205.mail.ir2.yahoo.com
Whole thread Raw
In response to Re: pg_dirtyread doesnt work  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
So I going to say, Alvaro.
The table structure should not create a table with TOAST


De: Alvaro Herrera <alvherre@2ndquadrant.com>
Para: Phil Sorber <phil@omniti.com>
CC: Alejandro Carrillo <fasterzip@yahoo.es>; "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Enviado: Viernes 28 de diciembre de 2012 15:10
Asunto: Re: [GENERAL] pg_dirtyread doesnt work

Phil Sorber escribió:
> Most likely it's because of TOAST'd records. The module is pretty
> naive and needs to be updated to handle such cases.

It doesn't look like a column with this definition would be toasted,
though:

> On Fri, Dec 28, 2012 at 10:53 AM, Alejandro Carrillo <fasterzip@yahoo.es> wrote:

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


--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_dirtyread doesnt work
Next
From: Wolfgang Keller
Date:
Subject: Re: Tool to create database diagrams in postgreSQL