Re: Surrogate primary key plus unique constraint vs. natural primary key: data integrity?
From: Wolfgang Keller <feliphil_at_gmx.net>
Date: Mon, 11 Mar 2013 19:54:05 +0100
Message-ID: <20130311195405.de036e78e3fb2104c63d6f89_at_gmx.net>
Date: Mon, 11 Mar 2013 19:54:05 +0100
Message-ID: <20130311195405.de036e78e3fb2104c63d6f89_at_gmx.net>
> >> (a) there's no such thing as a primary key;
> >
> > PostgreSQL seems to think differently. >;->
> >
> > It requires definition of a primary key afaik.
>
> No it doesn't.
I have to admit, my knowledge of PostgreSQL did not reach very far. ;-)
Thanks for the correction.
As too often, I just mis-took a personal habit (always define a primary key - don't slap me please) for a requirement.
Sincerely,
Wolfgang Received on Mon Mar 11 2013 - 19:54:05 CET