Re: problem with parent/child table and FKs

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: problem with parent/child table and FKs
Date: 2011-04-21 18:07:33
Message-ID: 20110421180733.GI3294@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joseph S 2011-04-21 18:41:06 getting EXPLAIN output from inside a function
Previous Message Greg Smith 2011-04-21 18:07:24 Re: Poor performance of btrfs with Postgresql