Re: what about uniqueness of inherited primary keys

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Andreas <maps(dot)on(at)gmx(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: what about uniqueness of inherited primary keys
Date: 2003-12-28 20:55:46
Message-ID: BC149162.3D835%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've been told that not all features of inheritance are implemented. What
this means in practice is that you often have to redeclare constraints on
inherited tables. So in your example you'd need to alter table persons and
add the constraint, but even then I think it might be possible to insert an
objects row and a person row with the same id.

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 665-7007 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2003-12-28 20:56:27 Re: what about uniqueness of inherited primary keys
Previous Message Tom Lane 2003-12-28 20:41:59 Re: [GENERAL] Strange permission problem regarding pg_settings