pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <gsmith@gregsmith.com>
To: pgsql-performance@postgresql.org
Subject: Re: Basic Q on superfluous primary keys
Date: Wed, 18 Apr 2007 08:19:55 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0704180814490.14766@westnet.com> (raw)
In-Reply-To: <4625E35C.2060708@archonet.com>
References: <c2350ba40704140419r2f3c85dfi60171759b71f4db7@mail.gmail.com>
	<20070414075947.e5fbeec8.wmoran@collaborativefusion.com>
	<b42b73150704160603x1d164134pfd2af7481f802ed9@mail.gmail.com>
	<46239000.7000708@modgraph-usa.com>
	<b42b73150704160855s676a8c43n7ef4282f5ef175c9@mail.gmail.com>
	<Pine.GSO.4.64.0704162239300.7058@westnet.com>
	<b42b73150704170917n33ebcdc8wc852a3fa02fd8bb5@mail.gmail.com>
	<46259937.7030502@modgraph-usa.com>
	<4625E35C.2060708@archonet.com>

On Wed, 18 Apr 2007, Richard Huxton wrote:

> And at the end of the day that's the root of the problem. It's easy to be 
> lulled into "well it looks like a primary key" rather than being able to 
> guarantee it.

In some of these cases it is guaranteed to be a primary key given all 
available information at the time.  The funny thing about unexpected 
changes to a business model is that you never expect them.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD



view thread (17+ messages)  latest in thread

Message-ID: <Pine.GSO.4.64.0704180814490.14766@westnet.com>
Permalink:  ../Pine.GSO.4.64.0704180814490.14766@westnet.com/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0704180814490.14766@westnet.com

 · 

reply
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-performance@postgresql.org
  Cc: gsmith@gregsmith.com
  Subject: Re: Basic Q on superfluous primary keys
  In-Reply-To: <Pine.GSO.4.64.0704180814490.14766@westnet.com>

* 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