Re: Forward declaration of table

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Forward declaration of table
Date: 2016-08-23 17:29:10
Message-ID: CAKFQuwZeOrDSiAK0GL9G1cvbx+5oLtzQhYuK2C=EEfWvKWWUHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 23, 2016 at 1:24 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

>
> use ALTER TABLE ADD table_constraint :
>
> https://www.postgresql.org/docs/9.5/static/sql-altertable.html
>
> to add the FK references to word_games.
>
>
​Hadn't considered "ALTER TABLE" but I'd be afraid of dump-restore hazards
here. Maybe pg_dump is smart enough to handle this correctly, though -
maybe by adding constraint definitions after all tables and columns are
present.

David J.​

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Periko Support 2016-08-23 17:35:02 Pentaho Odoo PSQL Slave.
Previous Message David G. Johnston 2016-08-23 17:27:05 Re: Forward declaration of table