Re: child fk problem

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Luis Silva <lfs12(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: child fk problem
Date: 2005-11-30 21:23:11
Message-ID: 1133385791.16010.15.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, 2005-11-30 at 12:42, Luis Silva wrote:
> I there, I'm trying to work with postgre, but i'm having a problem
> with inherits. I have a table (parent) that as an fk to another table.
> When i create a child, i loose the connection to the other table. i
> dont need to insert values in the parent table. what do i need to do??
> tks in advance

Neither indexes, nor triggers, nor foreign keys are inherited by child
tables. only the base structure of the parent.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-11-30 22:27:58 Re: Quote_literal()
Previous Message James M Doherty 2005-11-30 21:22:25 Re: quote_literal() fails with unmatched quotes