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(dot)Hilbert(at)gmx(dot)net
> ><mailto:Karsten(dot)Hilbert(at)gmx(dot)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