On Fri, 10 Oct 2003, Jodi Kanter wrote:
> Ok. sorry to confuse everyone...I got my restore to fun to completion so
> apparently my question about running restores in psql and the ordering
> of the data are not relevant.
> I do, however, have one other question I'd like to pose.
> I am getting serveral ref integrity errors which state that a FK value
> in one table does not exist in its parent table. However, when I go to
> the database to confirm this I can find no data that violates the
> constraint. Could the error be pointing to something less obvious?
Hmm, two possibilities I can think off the top of my head are if the fk
values are being inserted and erroring and the pk rows are being done
after (which would make a later check look like this) or if there's any
inheritance involved (where a plain select will show child rows that don't
currently participate in the foreign key constraint).