Search Postgresql Archives

Re: Enforce primary key on every table during dev?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Enforce primary key on every table during dev?
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Thu, 1 Mar 2018 13:12:21 -0700
Cc: Ron Johnson <ron.l.johnson@xxxxxxx>, "pgsql-generallists.postgresql.org" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAAZnbVq+GVQ_3x8E0yLM5zztGnqpkd8=Vft7tZ43Dxrt+WZvWQ@mail.gmail.com>
References: <C9EFC294-83B5-41FD-9542-60FDBB2588C6@gmail.com> <161e1761560-58a6-18e4b@webjas-vad211.srv.aolmail.net> <5a1870db-7018-fe15-ac60-ffe37abb7077@cox.net> <CAAZnbVr5=yScFCufRfpV0Kn0cJqoMMJ5CXKHvOa7Rja3sahE6A@mail.gmail.com> <CAKFQuwaYZnc=g5Jn_CWzXcner-NX3PyK03Xh8rH9nfqs+W55hg@mail.gmail.com> <CAAZnbVq+GVQ_3x8E0yLM5zztGnqpkd8=Vft7tZ43Dxrt+WZvWQ@mail.gmail.com>

On Thu, Mar 1, 2018 at 1:06 PM, Daevor The Devoted <dollien@xxxxxxxxx> wrote:

This seems like hierarchical data

Hence the "this is contrived" disclaimer - but if one allows for employee-department to be many-to-many, and thus requiring a joining table, this still applies even if the specific choice to nouns doesn't make sense.

David J.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Re: Enforce primary key on every table during dev?
  - From: Alban Hertroys
- Re: Enforce primary key on every table during dev?
  - From: Rakesh Kumar
- Re: Enforce primary key on every table during dev?
  - From: Ron Johnson
- Re: Enforce primary key on every table during dev?
  - From: Daevor The Devoted
- Re: Enforce primary key on every table during dev?
  - From: David G. Johnston
- Re: Enforce primary key on every table during dev?
  - From: Daevor The Devoted

Prev by Date: Re: Enforce primary key on every table during dev?
Next by Date: Re: Enforce primary key on every table during dev?
Previous by thread: Re: Enforce primary key on every table during dev?
Next by thread: Re: Enforce primary key on every table during dev?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]