Re: primary key and existing unique fields - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: primary key and existing unique fields
Date
Msg-id 417EB993.9080209@commandprompt.com
Whole thread Raw
In response to Re: primary key and existing unique fields  (Mike Mascari <mascarm@mascari.com>)
Responses Re: primary key and existing unique fields  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
>> Here is a good article on the topic:
>>
>> http://www.devx.com/ibm/Article/20702
>
> The surrogate key isn't solving the underlying logical inconsistency
> problem. It is being used as a work-around to cover one up. I suspect
> the author of being a MySQL user.

Actually he is a software project consultant for IEEE.org and he holds
a Ph.D. in Theoretical Physics.

Sincerely,

Joshua D. Drake


>
> Mike Mascari
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend


--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: basic debugging question
Next
From: Mike Mascari
Date:
Subject: Re: primary key and existing unique fields