Re: pg_dirtyread doesnt work

From: Alejandro Carrillo <fasterzip(at)yahoo(dot)es>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Phil Sorber <phil(at)omniti(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dirtyread doesnt work
Date: 2012-12-28 20:31:48
Message-ID: 1356726708.78061.YahooMailNeo@web172205.mail.ir2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

So I going to say, Alvaro.
The table structure should not create a table with TOAST

>________________________________
> De: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
>Para: Phil Sorber <phil(at)omniti(dot)com>
>CC: Alejandro Carrillo <fasterzip(at)yahoo(dot)es>; "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)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(at)yahoo(dot)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(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wolfgang Keller 2012-12-29 17:52:56 Re: Tool to create database diagrams in postgreSQL
Previous Message Alvaro Herrera 2012-12-28 20:10:07 Re: pg_dirtyread doesnt work