Re: Changing primary key and replicate this value

Article View: borland.public.interbase.replication

Article #5

Back to borland.public.interbase.replication Previous Next

From: Craig Stuntz TeamB
Date: Fri, 20 Feb 2004 16:25

20 lines
1619 bytes

David Domingo wrote:

> Then, what is the purpose of foreign keys with update cascade? ;)

	This changes the table that *references* the PK, not the PK value
itself.

	Repeat: Primary key values should never change.  If you ever feel the
need to change them then you have put business data in your PK, which
is a bad idea since PKs should never change.  :)

	In my ever-so-biased opinion,

	-Craig

-- 
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
  Delphi/InterBase Weblog : http://delphi.weblogs.com
Everything You Need to Know About InterBase Character Sets:
  http://delphi.weblogs.com/stories/storyReader$306

Technical Details

Message-ID: <403634e4$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <4034dce9$1@newsgroups.borland.com> <4034e8dc$1@newsgroups.borland.com> <4035deb9$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f89d7,2f886c55ebe3c509
X-Google-Attributes: gidf89d7,public
X-Google-ArrivalTime: 2004-02-20 08:40:39 PST
From: "Craig Stuntz [TeamB]" <cstuntz@nospam.please [a.k.a. vertexsoftware.com]>
Subject: Re: Changing primary key and replicate this value
Newsgroups: borland.public.interbase.replication
References: <4034dce9$1@newsgroups.borland.com> <4034e8dc$1@newsgroups.borland.com> <4035deb9$1@newsgroups.borland.com>
Organization: Vertex Systems Corporation
User-Agent: XanaNews/1.16.1.10
NNTP-Posting-Host: 24.106.104.202
Message-ID: <403634e4$1@newsgroups.borland.com>
Date: 20 Feb 2004 08:25:08 -0800
X-Trace: newsgroups.borland.com 1077294308 24.106.104.202 (20 Feb 2004 08:25:08 -0800)
Lines: 20
X-Authenticated-User: cstuntz
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message