Re: Foreign key constraint not enforced??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Moshe Jacobson <moshe(at)neadwerx(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, Robert Mowlavi <robert(at)neadwerx(dot)com>
Subject: Re: Foreign key constraint not enforced??
Date: 2014-04-24 15:34:14
Message-ID: 31609.1398353654@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Moshe Jacobson <moshe(at)neadwerx(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Moshe Jacobson 2014-04-24 16:06:17 Re: Foreign key constraint not enforced??
Previous Message Moshe Jacobson 2014-04-24 15:30:21 Re: Foreign key constraint not enforced??