Re: Removing constraints

[David Gibbs <david@xxxxxxxxxxxx>]

David Gibbs wrote:
> In fact, the current schema
> that we're finding isn't even logical.  There are foreign key
> constraints on files that should have a primary key constraint, but the
> primary key constraint isn't there.

That didn't sound right.

Let me try to restate it ... there are files with foreign key
constraints that point to other files with primary key constraints, but
the primary key constraints are missing.

When I restored the library, a bunch of diagnostic messages were logged
indicating that the constraints were invalid... and they complained
about files that should have had primary key constraints, but they were
missing.

david