From: | Bruce Richardson <brichardson(at)lineone(dot)net> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Sequences and inheritance |
Date: | 2001-07-31 14:18:35 |
Message-ID: | 20010731.14183500@usb.cafod |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If I have a set of tables and I set their primary keys all to the same
sequence, as in
create sequence common_seq;
create table alpha (
ID integer primary key default nextval('common_seq),
other_field text
);
create table beta (
ID integer primary key default nextval('common_seq),
other_field real
);
create table gamma (
ID integer primary key default nextval('common_seq),
other_field oid
);
Would this guarantee that each value of ID in any row of any of the
tables would be unique amongst all of them?
Would I get the same effect by creating a table like this:
create table common (
ID serial primary key
);
and then having alpha, beta and gamma inherit from it?
--
Bruce
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Finn | 2001-07-31 14:41:08 | Re: Getting Primary & Foreign Key Information? |
Previous Message | Bernie Holmes | 2001-07-31 13:45:06 | Getting Primary * Foreign Key Information? |