Sequences and inheritance
| От | Bruce Richardson |
|---|---|
| Тема | Sequences and inheritance |
| Дата | |
| Msg-id | 20010731.14183500@usb.cafod обсуждение исходный текст |
| Ответы |
Re: Sequences and inheritance
Re: Sequences and inheritance |
| Список | 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
В списке pgsql-general по дате отправления: