Re: Unique Primary Key Linked to Multiple Accounts - Mailing list pgsql-general

From David G. Johnston
Subject Re: Unique Primary Key Linked to Multiple Accounts
Date
Msg-id CAKFQuwZWNG9xavLTb_sJCLO3FUiV+w3Dgbk8cabd2GxWMFbPVQ@mail.gmail.com
Whole thread Raw
In response to Unique Primary Key Linked to Multiple Accounts  (Anthony Apollis <anthony.apollis@gmail.com>)
List pgsql-general
On Monday, November 13, 2023, Anthony Apollis <anthony.apollis@gmail.com> wrote:

Please advice.


The subset of data you’ve chosen to show does not allow one to draw any conclusions.  Look for the things that are different in the joined result - the things that are identical are mostly uninteresting when trying to figure out what additional join conditions are needed so that only a single matching row is found.

Your other table doesn’t have a primary key defined.  If you do that the answer will likely present itself to you.

David J.

pgsql-general by date:

Previous
From: Anthony Apollis
Date:
Subject: Unique Primary Key Linked to Multiple Accounts
Next
From: Justin Pryzby
Date:
Subject: Re: Properly handle OOM death?