Re: surrogate key or not?

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: sad <sad(at)bankir(dot)ru>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: surrogate key or not?
Date: 2004-07-21 10:58:35
Message-ID: 1090407515.3239.4.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

В Срд, 21.07.2004, в 09:44, sad пишет:

> 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,
and 5) applies.

> 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.

Спасибо

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message sad 2004-07-21 11:42:13 ? on announcement of 7.5
Previous Message sad 2004-07-21 10:30:16 Re: surrogate key or not?