Re: max freeze age query in docs - Mailing list pgsql-hackers

On 09/02/2013 01:30 PM, Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> Yes, possibly, but we can't do that now, but I would like to fix the
>> docs now.
> If you want this in 9.3.0 it needs to be committed in the next couple of
> hours.
>
> FWIW, the idea seemed generally sane to me, but I'd suggest not depending
> on reltoastrelid being zero when and only when there's no match.
> Why not test whether t.oid IS NULL, instead?
>
> Or actually, code it like this
>
>     GREATEST(age(c.relfrozenxid), age(t.relfrozenxid))
>
> and be done, as well as not having an ugly direct use of int4larger.
>
>         


OK, I'll do it that way. Working on it now.

cheers

andrew

cheers

andrew