On Wed, 29 Jun 2005, Eric D Nielsen wrote:
> > Stephan Szabo wrote:
> > On Wed, 29 Jun 2005, Richard Huxton wrote:
> > > Eric D. Nielsen wrote:
> > > > I've come into a situation where I will often need to merge two primary
> > > > keys, with numerous foreign keys hanging off of them. For instanc
> Stephan Szabo wrote:
> On Wed, 29 Jun 2005, Richard Huxton wrote:
> > Eric D. Nielsen wrote:
> > > I've come into a situation where I will often need to merge two primary
> > > keys, with numerous foreign keys hanging off of them. For instance:
> > > [ snip ]
> > > While any update of the either
On Wed, 29 Jun 2005, Richard Huxton wrote:
> Eric D. Nielsen wrote:
> > I've come into a situation where I will often need to merge two primary
> > keys, with numerous foreign keys hanging off of them. For instance:
>
> > While any update of the either primary key will cascade to all relevant
Eric D. Nielsen wrote:
I've come into a situation where I will often need to merge two primary
keys, with numerous foreign keys hanging off of them. For instance:
While any update of the either primary key will cascade to all relevant
tables, such an update is disallowed for uniqueness rea
I've come into a situation where I will often need to merge two
primary keys, with numerous foreign keys hanging off of them. For
instance:
CREATE TABLE people (
peopleid SERIAL PRIMARY KEY,
firstname TEXT NOT NULL,
lastname TEXT NOT NULL
);
CREATE TABLE users (
username TEXT PRIMAR
