On 20 Oct 2005 10:13:56 +0200, Harald Fuchs wrote:
> Jochem van Dieten writes:
>>
>> Back in reality you don't enforce this using DDL. Apart from the fact
>> that I wouldn't know a single database that implements ASSERTIONs
>> according to the SQL standard, can you imagine having to run some
>> SEL
In article <[EMAIL PROTECTED]>,
Jochem van Dieten <[EMAIL PROTECTED]> writes:
> Back in reality you don't enforce this using DDL. Apart from the fact
> that I wouldn't know a single database that implements ASSERTIONs
> according to the SQL standard, can you imagine having to run some
> SELECT fk
Hello Jochem,
> >> That doesn't help: check constraints are evaluated only on insert and
> >> update, not on delete. That's why you need an assertion.
> >
> > Hmmm, would that be SQL standard? Or implementation specific?
>
> It is at the very least implied in the SQL standard.
>
>
> > From a logic
On 10/20/05, Martijn Tonies wrote:
>>
>> That doesn't help: check constraints are evaluated only on insert and
>> update, not on delete. That's why you need an assertion.
>
> Hmmm, would that be SQL standard? Or implementation specific?
It is at the very least implied in the SQL standard.
> From
> First of all, is there any way of limiting the number of rows in a
> table, referencing to the same element of another table? For example,
> force a manager not to have more than 10 employees under his control.
> In a way this can be seen as checking the multiplicity of the
>
On 19 Oct 2005, at 20:30, Jochem van Dieten wrote:
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
First of all, is there any way of limiting the number of rows in a
table, referencing to the same element of another table? For
example,
force a manager not to have more than 10 empl
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>
First of all, is there any way of limiting the number of rows in a
table, referencing to the same element of another table? For example,
force a manager not to have more than 10 employees under his control.
In a way this c
> >> First of all, is there any way of limiting the number of rows in a
> >> table, referencing to the same element of another table? For example,
> >> force a manager not to have more than 10 employees under his control.
> >> In a way this can be seen as checking the multiplicity of the
> >> rela
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>>
>> First of all, is there any way of limiting the number of rows in a
>> table, referencing to the same element of another table? For example,
>> force a manager not to have more than 10 employees under his control.
>> In a way this can be s
On 19 Oct 2005, at 15:58, Martijn Tonies wrote:
Second, is there any way of getting more details out of an error
message? So for example, when doing a bulk upload to the database,
rather than just getting "Cannot add or update a child row: a foreign
key constraint fails" I would like to know
> As part of my 4th Year Group Design Project, I am required to build a
> database system that will validate and then store the data. As such I
> am currently investigating different DB, to choose the most suitable
> one. I like many features of MySQL but there are a couple of things I
> am not
As part of my 4th Year Group Design Project, I am required to build a
database system that will validate and then store the data. As such I
am currently investigating different DB, to choose the most suitable
one. I like many features of MySQL but there are a couple of things I
am not very
12 matches
Mail list logo
