Re: not(t_xmax = 0)

Lists: pgsql-general
From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "Alejandro Carrillo" <fasterzip(at)yahoo(dot)es>,pgsql-general(at)postgresql(dot)org
Subject: Re: not(t_xmax = 0)
Date: 2013-01-20 17:19:12
Message-ID: 20130120171913.108960@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Alejandro Carrillo wrote:

> I need to filter xid != 0. I tried this "not(t_xmax = 0)" but I
> dont sure that this work ok
>
> How I do it?

Please give a high-level description of what you are trying to
accomplish and why. I didn't find it at all clear from your sample
function,

-Kevin


From: Alejandro Carrillo <fasterzip(at)yahoo(dot)es>
To: Kevin Grittner <kgrittn(at)mail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: not(t_xmax = 0)
Date: 2013-01-20 19:22:40
Message-ID: 1358709760.16799.YahooMailNeo@web172206.mail.ir2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

I try to do a function that let know which rows are deleted in a table using the xmax !=0

>________________________________
> De: Kevin Grittner <kgrittn(at)mail(dot)com>
>Para: Alejandro Carrillo <fasterzip(at)yahoo(dot)es>; pgsql-general(at)postgresql(dot)org
>Enviado: Domingo 20 de enero de 2013 12:19
>Asunto: Re: [GENERAL] not(t_xmax = 0)
>
>Alejandro Carrillo wrote:
>
>> I need to filter xid != 0. I tried this "not(t_xmax = 0)" but I
>> dont sure that this work ok
>>
>> How I do it?
>
>Please give a high-level description of what you are trying to
>accomplish and why. I didn't find it at all clear from your sample
>function,
>
>-Kevin
>
>
>--
>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
>
>
>