Postgres Pro
Downloads
Home   >   mailing lists

What is the difference of these two kinds of foreign key defination? - Mailing list pgsql-general

From sheepjxx
Subject What is the difference of these two kinds of foreign key defination?
Date
Msg-id 37a11ce00909240748j4d9d8e4j5108e2fbbeb96e0f@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
To be precise,
 
The difference between

create table a (
     foreign key (id) referenced by b(name),
);

create table b(
      id  integer referenced by b(name),
);

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Understanding 'could not read block'
Next
From: Cédric Villemain
Date:
Subject: Re: Looking for way to replicate master db to multiple mobile databases