On Sun, 2004-08-29 at 18:07, Matthew M Davis wrote:
> On Sunday 29 August at 12:34pm, Oliver Elphick had this to say:
>
> > Primary and foreign key constraints are not inherited. This is a defect
> > in the current system.
>
> It almost seems like a FEATURE to me, since it creates a different an
On Sunday 29 August at 12:34pm, Oliver Elphick had this to say:
> Primary and foreign key constraints are not inherited. This is a defect
> in the current system.
It almost seems like a FEATURE to me, since it creates a different and
easy way to create one-to-many relationships. But I didn't us
On Fri, 2004-08-27 at 11:58, Bruno Baguette wrote:
> Hello,
>
> 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.
...
> The error I get is :
> ERROR: there is no unique constraint matching given keys for refe
On Fri, 27 Aug 2004, Bruno Baguette wrote:
> Hello,
>
> 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 PRIM
Hello,
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,
myfoo_name VARCHAR(10)
);
CREATE TABL
