Sequences and inheritance

Поиск
Список
Период
Сортировка
От Bruce Richardson
Тема Sequences and inheritance
Дата
Msg-id 20010731.14183500@usb.cafod
обсуждение исходный текст
Ответы Re: Sequences and inheritance  (Einar Karttunen <ekarttun@cs.Helsinki.FI>)
Re: Sequences and inheritance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Dave Cramer"
Дата:
Сообщение: RE: Please Help JDBC Error!!
Следующее
От: Einar Karttunen
Дата:
Сообщение: Re: Sequences and inheritance