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@xxxxxxx > ><mailto:Karsten.Hilbert@xxxxxxx>> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
