Re: 8.4.0 bug - failure to enforce a foreign key constraint

From: Radoslaw Zielinski *EXTERN* <radek(at)pld-linux(dot)org>
To: pgsql-general(at)postgresql(dot)org
Cc: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Subject: Re: 8.4.0 bug - failure to enforce a foreign key constraint
Date: 2009-08-14 08:03:37
Message-ID: 20090814080337.GA4035@bzium
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> [2009-08-14 07:34]:
> Radoslaw Zielinski wrote:
[...]
>> The "orphans" count should be 0, obviously.
> Just to make sure that there is really an inconsistency:

> Could you pg_dump both tables and try to load them into
> another database? If that works without errors, we must have
> missed something obvious.

Yes, I did that. In fact, that's how I have noticed this -- by reading
pg_dump's output.

--
Radosław Zieliński <radek(at)pld-linux(dot)org>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2009-08-14 09:23:02 FILLFACTOR for GIN indexes in 8.3.7
Previous Message Chris 2009-08-14 07:45:47 Re: drop key translation