Re: problem with parent/child table and FKs - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: problem with parent/child table and FKs
Date
Msg-id 20110421180733.GI3294@hermes.hilbert.loc
Whole thread Raw
In response to Re: problem with parent/child table and FKs  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
On Thu, Apr 21, 2011 at 07:15:38PM +0200, Alban Hertroys wrote:

> BTW, do you really need those artificial PK's? If not, you
> may well be better off dropping them. That way (code, term)
> could be your PK instead. I don't know enough about your
> data to make more than a guess though, I just get itchy when
> I see such designs ;)

Well, coding system content changes at the whims of
governments, professional boards, the winds of change, and
the hair color of the director of WHO...

Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Poor performance of btrfs with Postgresql
Next
From: Joseph S
Date:
Subject: getting EXPLAIN output from inside a function