> -----Original Message-----
> From: olivier_olmer [mailto:olivier_olmer@...]
> Sent: Thursday, 19 June 2003 9:49 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Insert succesfull while violating
> primary key constraint
>
>
> Hi Helen,
>
> You are right! Thank you The indexes are disabled. Actually all the
> indexes of all tables are inactive. Since I know for sure we did not
> alter indexes to deactivate them. Simply we did not know this feature.
>
> I like to know what else could cause this to happen.
> The only thing we have done is dropping foreign key constraints to
> speed up the delete of about 4.000.0000 records.
>
> With kind regards,
>
> Olivier Olmer
> Oxolutions
>
>

Olivier,
You might also be even more excited to learn about the real use of
domains...
The idea is to define a (one) domain and use it over and over when you are
defining fields of the same datatype. In your database you have defined an
integer domain over and over and over and used each domain (describing the
same datatype) to each new field of that same datatype. There's a lot of
redundancy there.
Make one domain MYINTEGERDOMAIN of type integer, then when you want an
integer - use MYINTEGERDOMAIN to define it.

Alan