[50930] in SAPr3-news
Re: Is it possible to create foreign keys at DB level?
daemon@ATHENA.MIT.EDU (Ivaylo Mutafchiev)
Tue Aug 3 02:48:21 2004
To: sapr3-news@mit.edu
Date: Tue, 3 Aug 2004 09:48:09 +0300
From: "Ivaylo Mutafchiev" <ism_NoSpamPlease@mail.bg>
Message-ID: <2n8qpfFulconU1@uni-berlin.de>
Thanks,
I won't do that. I found 2 misleading points followed by this restriction:
1. I should allways consider eventual restrictions and check in my programs
if there is possible integrity violation. That's okay - I'll do that, I
simply can't be 100% sure all the programs are written this way.
2. When someone asks how to delete some, for example, documents, and there
are answers like: 'Fisrt delete header, after that delete items', for me, as
a db designer, it sounds nuts - and it's hard to not start complaining
against such answer :-). Ok, I think I should reconcile with this too...
Thanks again.
Ivaylo
"Markus Humm" <markus.humm1@freenet.de> wrote in message
news:410e998e$0$802$9b622d9e@news.freenet.de...
> You shouldn't do that! You circumwent SAPs mechanisms which MAY lead to
> some situations you don't want to have...
>
> Greetings
>
> Markus
