How to have a unique primary key on two tables - Mailing list pgsql-sql

From Daniel \"bodom_lx\" Graziotin
Subject How to have a unique primary key on two tables
Date
Msg-id 99d8c2310711220301p57c9b7c5i4620a7e658d13b7d@mail.gmail.com
Whole thread Raw
Responses Re: How to have a unique primary key on two tables  ("Bart Degryse" <Bart.Degryse@indicator.be>)
Re: How to have a unique primary key on two tables  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List 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 by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Bad Schema Design or Useful Trick?
Next
From: "Bart Degryse"
Date:
Subject: Re: How to have a unique primary key on two tables