Re: [GENERAL] Q: inheritance

2008-12-04 Thread Richard Broersma
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

Re: [GENERAL] Q: inheritance

2008-12-04 Thread Richard Huxton
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