Home > mailing lists

Re: Forward declaration of table - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: Forward declaration of table
Date	August 23, 2016 20:27:10
Msg-id	CAKFQuwaKhPN3GQ7HShmaM4qorqKq64ezrLGAJSVC49g-xx9o1A@mail.gmail.com Whole thread Raw
In response to	Forward declaration of table (Alexander Farber <alexander.farber@gmail.com>)
List	pgsql-general

On Tue, Aug 23, 2016 at 1:10 PM, Alexander Farber <alexander.farber@gmail.com> wrote:

So my question is if I can somehow "forward declare" the words_moves table?

A better way to phrase this is:

Is it possible to create circular foreign key dependencies between tables?

The answer is no.

You generally need to introduce a third table. I haven't delved deep enough into your scenario to be more specific.

David J.

From: Adrian Klaver
Date: 23 August 2016, 20:24:20
Subject: Re: Forward declaration of table

From: "David G. Johnston"
Date: 23 August 2016, 20:29:16
Subject: Re: Forward declaration of table