Re: partial "on-delete set null" constraint

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: partial "on-delete set null" constraint
Дата
Msg-id 4C78E65A-F903-46AF-AD26-4E30310264B0@gmail.com
обсуждение исходный текст
Ответ на Re: Fwd: partial "on-delete set null" constraint  (rob stone <floriparob@gmail.com>)
Ответы Re: partial "on-delete set null" constraint  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Список pgsql-general
> On Sun, 2015-01-25 at 14:09 +0100, Alban Hertroys wrote:
>
> The following link
>
> http://www.databaseanswers.org/codds_rules.htm
>
> sets out Ted Codd's rules according to C.J. Date.

As you might have noticed, those were referred to already upthread, but that is a while ago now.
Although those rules are certainly Codd's, that's an entirely different bit of database theory. It's what I did manage
tofind while searching the Internet for Codd relationality. 

What I understand of them, these 12 rules determine whether a DBMS can be called relational, whereas Codd-relationality
isonly applicable in DBMS's that already qualify as relational and restricts primary keys to non-nullable fields. 

I know it's hard to believe that the Internet does not contain some information, certainly when the information is a
rulethat is applied and documented in pretty much every relational database in existence (but without mentioning it by
nameor why it exists). I'm afraid that might be the case here though. Possibly this could happen because the theory in
questionpredates the internet. 

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.



В списке pgsql-general по дате отправления:

Предыдущее
От: rob stone
Дата:
Сообщение: Re: Fwd: partial "on-delete set null" constraint
Следующее
От: Paul Jungwirth
Дата:
Сообщение: Re: partial "on-delete set null" constraint