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

From Konrad Garus
Subject Re: Rows missing from table despite FK constraint
Date
Msg-id 6645f6441001080900w4fa346d1me66cb0cf1307c05d@mail.gmail.com
Whole thread Raw
In response to Re: Rows missing from table despite FK constraint  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Rows missing from table despite FK constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
2010/1/8 Alvaro Herrera <alvherre@commandprompt.com>:

> I'm a bit surprised by the block numbers in the block header vs. t_self ...
> I would have guessed that they come from a different segment (and
> the numbers seem to match, as 603713 % 131072 = 79425), but Konrad
> doesn't seem to be using the foo.4 file.

I am not sure I understand what you say, but the 922494 file has 12
parts (922494, 922494.1 through 922494.11). The file I gave you is,
indeed, dumped from 922494.4.

--
Konrad Garus

pgsql-general by date:

Previous
From: Mark Morgan Lloyd
Date:
Subject: Re: Server name in psql prompt
Next
From: Adrian Klaver
Date:
Subject: Re: Server name in psql prompt