| From: | Konrad Garus <konrad(dot)garus(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Rows missing from table despite FK constraint |
| Date: | 2010-01-08 15:39:53 |
| Message-ID: | 6645f6441001080739w7549324rba4c8b469f62c060@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2010/1/8 Konrad Garus <konrad(dot)garus(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Konrad Garus | 2010-01-08 15:59:00 | Re: Rows missing from table despite FK constraint |
| Previous Message | Konrad Garus | 2010-01-08 15:30:03 | Re: Rows missing from table despite FK constraint |