Re: Purely declarative FKs

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Purely declarative FKs
Date: 2023-10-16 08:43:30
Message-ID: 60D62406-E176-4F93-B9B4-C1C6CFA66B84@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Oct 16, 2023, at 00:51, Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> wrote:
> Question: Are there plans to provide a feature in PostgreSQL that one can have foreign keys for purely documentation purpose - I know, one could use a modelling tool and just not implement the FKs, but my reality is, there is hardly ever a modelling tool involved.

The answer to the specific question is, no, I don't believe that there any plans to implement purely documentary foreign keys.

If you need this information, and need it stored with the schema (as opposed to external documentation), database comments are the most reasonable place to put it.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jehan-Guillaume de Rorthais 2023-10-16 13:20:56 Re: Postgresql HA cluster
Previous Message Thiemo Kellner 2023-10-16 07:51:44 Purely declarative FKs