Re: PostgreSQL Developer Best Practices

On Tue, Aug 25, 2015 at 02:02:17PM +1200, Gavin Flower wrote:

> On 25/08/15 01:15, Ray Cote wrote:
> >On Sat, Aug 22, 2015 at 11:46 AM, Karsten Hilbert <Karsten.Hilbert@gmx.net
> ><mailto:Karsten.Hilbert@gmx.net>> wrote:
> >
> [...]
> >
> >    9. Do NOT arbitrarily assign an "id" column to a table as a
> >    primary key when other columns
> >        are perfectly suited as a unique primary key.
> >
> >    ...
> >
> >          Good example:
> >            CREATE TABLE accounts
> >            ( accout_id bigint NOT NULL ,
> >
> >
> >I would not consider the general use of natural primary keys to be best
> >practice.

Gavin, Ray,

I certainly didn't write any of the above.

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346