How to have a unique primary key on two tables

Поиск
Список
Период
Сортировка
От Daniel \"bodom_lx\" Graziotin
Тема How to have a unique primary key on two tables
Дата
Msg-id 99d8c2310711220301p57c9b7c5i4620a7e658d13b7d@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to have a unique primary key on two tables
Re: How to have a unique primary key on two tables
Список pgsql-sql
Hi everybody,
I need to have a primary key which has to be unique on two tables.
E.g.:

CREATE TABLE first
( id serial NOT NULL, testo text,
)

CREATE TABLE second
( id serial NOT NULL, testo text,
)

When I insert some text on "first", I would like first.id = second.id
+ 1, and vice versa.
A sort of primary key in common for both tables.

Any hints?
Thank you very much
-- 
Daniel "bodom_lx" Graziotin
- http://daniel.graziotin.net
- http://daniel.graziotin.net/bodom_lx.asc - GPG public key


В списке pgsql-sql по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Bad Schema Design or Useful Trick?
Следующее
От: "Bart Degryse"
Дата:
Сообщение: Re: How to have a unique primary key on two tables