On Fri, 16 Nov 2007 13:35:40 GMT, "Hans Baele"
<hans.baele@xxxxxxxxxx> wrote:
Has anyone a solution?
In most such situations it makes sense to open the database in
sungle-user mode (i.e., locked for other users) until the data has
been moved. Then you can remove or disable the primary key
constraint(s) and re-create it/them once all the data has been
migrated. Besides, inserts will be much faster if there are no
constraints in force.
Re: A real world example ... If a constraint is defined in terms of successive states of a database,... Yes, that's all facts are, though constraints mean that your facts are ... value of a candidate key determines the values of all other attributes, ... The frame of reference for a candidate key is a ... (comp.databases.theory)
Re: A real world example ... If a constraint is defined in terms of successive states of a database,... facts cannot be thought of just in terms of instances of predicates.... Yes, that's all facts are, though constraints mean that your facts are ... (comp.databases.theory)
Re: A real world example ... If a constraint is defined in terms of successive states of a database,... Yes, that's all facts are, though constraints mean that your facts are ... model already allows surrogate keys.... (comp.databases.theory)
Re: A real world example ... If a constraint is defined in terms of successive states of a database,... facts cannot be thought of just in terms of instances of predicates.... Yes, that's all facts are, though constraints mean that your facts are ...referencing all of the attribute values, nor, given only the key value, ... (comp.databases.theory)
Re: Declarative constraints in practical terms ... It is a portion of one or more software applications,... The definition of a database should be all that is required to ...Constraints are an integral ...declarative constraints: SQL declarations enforced by a DBMS engine ... (comp.databases.theory)
