From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Luis Silva <lfs12@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: child fk problem
Date: Wed, 30 Nov 2005 15:23:11 -0600
Message-ID: <1133385791.16010.15.camel@state.g2switchworks.com> (raw)
In-Reply-To: <BAY18-DAV6BEE61548633F22F1E87FB54A0@phx.gbl>
References: <BAY18-DAV6BEE61548633F22F1E87FB54A0@phx.gbl>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: smarlowe@g2switchworks.com, lfs12@hotmail.com
Subject: Re: child fk problem
In-Reply-To: <1133385791.16010.15.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox