From: sad <sad@bankir.ru>
To: Markus Bertheau <twanger@bluetwanger.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: surrogate key or not?
Date: Wed, 21 Jul 2004 14:30:16 +0400
Message-ID: <200407211430.16674.sad@bankir.ru> (raw)
In-Reply-To: <1090407515.3239.4.camel@dicaprio.akademie1.de>
References: <1090325769.3241.27.camel@dicaprio.akademie1.de>
<200407211144.01001.sad@bankir.ru>
<1090407515.3239.4.camel@dicaprio.akademie1.de>
On Wednesday 21 July 2004 14:58, Markus Bertheau wrote:
> > 4) Replication: to identify an object of ANY type (record of any table
> > regardless to datamodel), to store lists of deleted or modified objects
> > (regardless to datamodel)
>
> That sounds like a datamodel on data that belongs to another data model,
that's right, these surr. keys actually belong to a metadata model,
but it is also useful to references of a data model. and they are used this
way.
> > 5) Making a primary key: if there is no real key at all.
>
> When there's no key at all, there can't be a surrogate key, as I
> understand it. In such cases a generated unique number comes in handy,
> and it's a real primary key and no surrogate key.
...right. in case (5) we construct another datamodel indeed. with an
artifichial real key :-)
P.S. r u from Russia ?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sad@bankir.ru, twanger@bluetwanger.de
Subject: Re: surrogate key or not?
In-Reply-To: <200407211430.16674.sad@bankir.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox