Re: inherited, unique serial field...

On Friday 07 February 2003 04:15 pm, you wrote:
> id | created | class
> ----+------------+----------
> 4 | 2003-02-06 | other
> 4 | 2003-02-06 | person
>
> even tho track.id is constrained to be unique, voila! we've got
> duplicate "primary keys". is this evil enough to avoid -- or is
> it innocuous?

But they are not in same table, are they? I mean if you select on base table,
how do you expect primary key constraint to be held against n child tables?

I dunno what standard says about this. But as long as, select from child table
on primary key does not return duplicate row, I wouldn't worry.

This can be a really annoying issue for somebody. But I would advice him/her
to work on table design rather than proposing it as a defect in PG.

Shridhar