Re: Rows missing from table despite FK constraint - Mailing list pgsql-general

2010/1/8 Konrad Garus <konrad.garus@gmail.com>:

> I'm unsure about it, because the resulting file does not seem to have
> the rows I saw listed for block 603712 or 603714. I checked by text in
> VARCHAR columns.

I must've done something wrong.

I found that row listed at:

Block 603712 ********************************************************
(header etc.)
 Item  15 -- Length:  184  Offset: 5496 (0x1578)  Flags: NORMAL
  XMIN: 8124  XMAX: 0  CID|XVAC: 0
  Block Id: 79424  linp Index: 15   Attributes: 19   Size: 32
  infomask: 0x0903 (HASNULL|HASVARWIDTH|XMIN_COMMITTED|XMAX_INVALID)
  t_bits: [0]: 0xff [1]: 0x79 [2]: 0x07

Has ctid equal (79424,15).

How do I run pg_filedump for rows with ctid between (603712,78) and (603714,1)?

--
Konrad Garus