Re: foreign keys and inheritance problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Edoardo Panfili <edoardo(at)aspix(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: foreign keys and inheritance problem
Date: 2010-08-12 18:44:23
Message-ID: 3001.1281638663@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Edoardo Panfili <edoardo(at)aspix(dot)it> writes:
> On 12/08/10 18.59, Edoardo Panfili wrote:
>> I am in some trouble with my tables defined using inheritance,

No, foreign keys do not play very nicely with inheritance. There is
some explanation in the manual, in the "Caveats" subsection under
"Inheritance" --- see bottom of this page:
http://www.postgresql.org/docs/8.4/static/ddl-inherit.html

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Boreham 2010-08-12 18:50:11 Re: MySQL versus Postgres
Previous Message Peter Geoghegan 2010-08-12 18:43:50 Setting up pgpass.conf for the postgres OS user on windows for pgAgent