Postgres Pro
Downloads
Home   >   mailing lists

Re: foreign keys and inheritance problem - Mailing list pgsql-general

From Tom Lane
Subject Re: foreign keys and inheritance problem
Date
Msg-id 3001.1281638663@sss.pgh.pa.us
Whole thread Raw
In response to Re: foreign keys and inheritance problem  (Edoardo Panfili <edoardo@aspix.it>)
Responses Re: foreign keys and inheritance problem  (Edoardo Panfili <edoardo@aspix.it>)
List pgsql-general
Tree view 
Edoardo Panfili <edoardo@aspix.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

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Setting up pgpass.conf for the postgres OS user on windows for pgAgent
Next
From: David Boreham
Date:
Subject: Re: MySQL versus Postgres