I've a strange problem with inheritance on PostgreSQL 7.4.1. It seems
like tables don't inherits the primary key of the 'mother' table.
Here's a little sample to show my problem :
CREATE TABLE foo_a
pk_idmyfoo INT2 PRIMARY KEY NOT NULL,
CREATE TABLE child_foo
) INHERITS (foo_a);
CREATE TABLE childfoo_bookmarks
fk_idchildfoo INT2 NOT NULL REFERENCES child_foo (pk_idmyfoo),
The error I get is :
ERROR: there is no unique constraint matching given keys for referenced
What can I do to solve that problem ?
Thanks in advance for your help !
Bruno Baguette - pgsql-ml(at)baguette(dot)net
pgsql-general by date
|Next:||From: David Wheeler||Date: 2004-08-27 11:54:29|
|Subject: Re: UTF-8 and LIKE vs =|
|Previous:||From: Oliver Elphick||Date: 2004-08-27 09:08:10|
|Subject: Re: Creating Functions in Separate Schema|