Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign key constraint not enforced?? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Foreign key constraint not enforced??
Date
Msg-id 31609.1398353654@sss.pgh.pa.us
Whole thread Raw
In response to Foreign key constraint not enforced??  (Moshe Jacobson <moshe@neadwerx.com>)
Responses Re: Foreign key constraint not enforced??  (Moshe Jacobson <moshe@neadwerx.com>)
List pgsql-bugs
Tree view 
Moshe Jacobson <moshe@neadwerx.com> writes:
> I'm not sure what is going on here. I feel like I'm missing something
> obvious. Seems like a bug, so I'm posting on -bugs.

Just guessing from the mention of child tables in the \d output:
you do realize that foreign key constraints don't bind child tables?
See "Caveats" at the bottom of
http://www.postgresql.org/docs/9.3/static/ddl-inherit.html

            regards, tom lane

pgsql-bugs by date:

Previous
From: Moshe Jacobson
Date:
Subject: Re: Foreign key constraint not enforced??
Next
From: Moshe Jacobson
Date:
Subject: Re: Foreign key constraint not enforced??