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 по дате отправления: