Re: inheritance - Mailing list pgsql-novice

From Pablo Dejuan
Subject Re: inheritance
Date
Msg-id 3F0C4C7F.3020700@ucu.edu.uy
Whole thread Raw
In response to Re: inheritance  (Jake Stride <nsuk@users.sourceforge.net>)
List pgsql-novice
Jake Stride wrote:

>...
>
>As to duplicate keys, you can recreate the primary key in each inherited
>table. Also shouldn't you be updating in the relavent table?
>
>
>
Hello, I don't really get the idea of inheritance, what's 'recreating' a
primary key?
Let's say CITIES has as pk CITY_NUMBER as Serial.
How do you recreate the primary key in CAPITALS?
 Would you create a integer 'pointing' the sequence of CITY_NUMBER?

T.I.A.

Pablo




pgsql-novice by date:

Previous
From: Jake Stride
Date:
Subject: Re: inheritance
Next
From: Dmitry Tkach
Date:
Subject: Re: inheritance