Re: Forward declaration of table

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Forward declaration of table
Date: 2016-08-23 17:27:05
Message-ID: CAKFQuwaKhPN3GQ7HShmaM4qorqKq64ezrLGAJSVC49g-xx9o1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 23, 2016 at 1:10 PM, Alexander Farber <
alexander(dot)farber(at)gmail(dot)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.
​

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-08-23 17:29:10 Re: Forward declaration of table
Previous Message Adrian Klaver 2016-08-23 17:24:12 Re: Forward declaration of table