Postgres Pro
Downloads
Home   >   mailing lists

Re: Whither 1:1? - Mailing list pgsql-general

From James Keener
Subject Re: Whither 1:1?
Date
Msg-id CAG8g3tz72AMtmHrzB9CuN0gpr_oH2nKRg=0-GC3QOdJC+C_tAA@mail.gmail.com
Whole thread Raw
In response to Whither 1:1?  (Guyren Howe <guyren@gmail.com>)
Responses Re: Whither 1:1?  (Guyren Howe <guyren@gmail.com>)
List pgsql-general
Tree view
I don't think I fully understand. Do you mean all pk using a single sequence? I'm not sure how this would avoid nulls or grouping fields.

Jim

On Fri, Jun 1, 2018 at 12:52 PM, Guyren Howe <guyren@gmail.com> wrote:
It’s come to my attention that what seems an obvious and useful database design pattern — 1:1 relations between tables by having a shared primary key — is hardly discussed or used.

It would seem to be a very simple pattern, and useful to avoid storing nulls or for groups of fields that tend to be used together.

Thoughts? Is there some downside I can’t see?

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Whither 1:1?
Next
From: Pavel Stehule
Date:
Subject: Re: Whither 1:1?