Re: Multiple table entries?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Jeff Ross <jross(at)wykids(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multiple table entries?
Date: 2009-08-23 22:58:52
Message-ID: 407d949e0908231558s3dec5e36k9e62e3a7da95b2c6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Aug 23, 2009 at 9:06 PM, Jeff Ross<jross(at)wykids(dot)org> wrote:
> pglogd=# select (h).* from (select
>  page_header(get_raw_page('pg_namespace',0))
> pglogd(# as h) as x;
>   lsn    | tli | flags | lower | upper | special | pagesize | version |
> prune_xid
> -----------+-----+-------+-------+-------+---------+----------+---------+-----------
> 0/1A15904 |   1 |     5 |    64 |  6944 |    8192 |     8192 |       4 |
>   897

Well this confirms that the bug involves the all-visible flag as the 5
is PD_ALL_VISIBLE + PD_HAS_FREE_LINES

It's been overtaken by events as Tom has spotted a problem already.
--
greg
http://mit.edu/~gsstark/resume.pdf

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-08-24 01:03:36 Re: Multiple table entries?
Previous Message Andrew Cooper 2009-08-23 21:10:38 Re: Figuring out relationships between tables.