On Thu, Dec 4, 2008 at 8:40 AM, Rüdiger Sörensen
<[EMAIL PROTECTED]> wrote:
> insert or update in table "t3" violates foreign key constraint "t3_t1_fkey"
> DETAIL: key(t1)=(1) is not present in table "t1"
> select * from t2;
> id | num
> +-
> 1 | 1
> can anyone explain this behaviour
Rüdiger Sörensen wrote:
> can anyone explain this behaviour? My database setup relies on inherited
> tables that share a primary key.
I'm afraid inherited tables don't share a primary key. See the manuals
for full details.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing li
hi,
I think I misunderstand the concept of inheritance. I was under the
impression that inheriting from an existing table inherits all of the
parent's columns.
But:
create table t1 (id serial primary key);
create table t2 (num int) inherits (t1);
create table t3 (t1 int references t1(id));
inse
