Hi All.
I asked a question in group "novice" but haven't got an answer,
therefore decided to ask here.
How to inherit primary key?
For example, i have created tables
create table t1(
id int4 .... primary key
)
create table t2(
name text
)
inherits (t1)
and i would like to have id as a primary key in t2. But when i look at
the list of indexes in pg_index, i see there are t1_pkey - index for
primary key in t1, but don't see the same for t2, so id is not a primary
key in t2.
I tried
create table t2(
name text
primary key (id)
)
inherits (t1)
but got an error.
How i can make field id as a primary key in t2?
Thank you in advance.
Sincerely yours, Yury.
don.web-page.net, ICQ 11831432