Re: Removing constraints

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

David,

Did the original owners restore into the orignal library or in a test library? 
They encountered the same problems you have now.

I think it might be a "chicken or egg"-problem. Similar to first restoring LFs 
and the based PF has not been restored yet.

Have you tried to restore this library again? All the required objects are in 
that library again. So, if a depending constraint should be restored it can 
find the base object.

Just a thought.

Regards,
Carel Teijgeler 

*********** REPLY SEPARATOR  ***********

On 2-4-05 at 17:52 David Gibbs wrote:

>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.