Re: database design and refactoring - Mailing list pgsql-general

From Erik Jones
Subject Re: database design and refactoring
Date
Msg-id 459D5992.5050406@myemma.com
Whole thread Raw
In response to Re: database design and refactoring  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general
Michael Glaesemann wrote:
>
> On Jan 3, 2007, at 5:24 , Luca Ferrari wrote:
>> And moreover a database design question: is a better idea to choose
>> always
>> (when possible) numeric keys?
>
> Depends on your requirements. This is an oft-discussed topic about
> which you can find many more opinions by googling on natural and
> surrogate keys.
Come on, it's been a whole, what?, three or four weeks since the last
natural v. surrogate debate?  Seriously though, Luca, for information on
that vein, peruse the archives or do as Michael suggested and Google.


--
erik jones <erik@myemma.com>
software development
emma(r)


pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: Using duplicate foreign keys
Next
From: Tom Lane
Date:
Subject: Re: Any form of connection-level "session variable" ?