Postgres Pro
Downloads
Home   >   mailing lists

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 417E9C73.6000503@commandprompt.com
Whole thread Raw
In response to Re: primary key and existing unique fields  ("Sally Sally" <dedeb17@hotmail.com>)
Responses Re: primary key and existing unique fields  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
Tree view 
Sally Sally wrote:
> Can you please elaborate on the point you just made as to why the
> primary key should not relate to the data (even for a case when there is
> an existing unique field that can be used to identify the record)
>

Here is a good article on the topic:

http://www.devx.com/ibm/Article/20702


Sincerely,

Joshua D. Drake



--
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: Kevin Barnard
Date:
Subject: Re: what could cause inserts getting queued up and db locking??
Next
From: Együd Csaba (Freemail)
Date:
Subject: Re: Error restoring bytea from dump