Re: Multiple table entries? - Mailing list pgsql-general

From Greg Stark
Subject Re: Multiple table entries?
Date
Msg-id 407d949e0908231558s3dec5e36k9e62e3a7da95b2c6@mail.gmail.com
Whole thread Raw
In response to Multiple table entries?  (Jeff Ross <jross@wykids.org>)
List pgsql-general
On Sun, Aug 23, 2009 at 9:06 PM, Jeff Ross<jross@wykids.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

pgsql-general by date:

Previous
From: Andrew Cooper
Date:
Subject: Re: Figuring out relationships between tables.
Next
From: Tom Lane
Date:
Subject: Re: Multiple table entries?