Re: PostgreSQL Developer Best Practices - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: PostgreSQL Developer Best Practices
Date
Msg-id trinity-59cdef70-7917-48a9-bc8c-6bbb989f543c-1440521048348@3capp-gmx-bs21
Whole thread Raw
In response to Re: PostgreSQL Developer Best Practices  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
> No one ever said a number is not natural. just that there is no need to duplicate uniqueness
> with a separate number.

The whole point is that people are telling you that surrogate keys do not _duplicate_ uniqueness but
rather _generate_ it, artificially, and therefore reliably.

Today's external uniqueness is ambiguous tomorrow.

Karsten


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL Developer Best Practices
Next
From: Adam Brusselback
Date:
Subject: Re: PostgreSQL Developer Best Practices