2007-11-22 = 12:01 >>> 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 =3D second.id + 1, and vice versa. A sort of primary key in common for both tables. Any hints? Thank you very much --=20 Daniel "bodom_lx" Graziotin - http://daniel.graziotin.net ( http://daniel.graziotin.net/ ) - http://daniel.graziotin.net/bodom_lx.asc - GPG public key ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq --=__PartC1E7CEC8.0__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML

When you use serial a kind of macro is performed: in fact an integer = field is created, a sequence is created with a name based on the = table's name and the nextval of that sequence is used as the default value = for the field. Now you have to do these steps "manually".

CREATE SEQUENCE "public"."tbl_all_ID_seq" INCREMENT 1 MINVALUE 1 = START 1 CACHE 1;

CREATE TABLE tbl_first (
id INTEGER DEFAULT = nextval('public."tbl_all_ID_seq"'::text) NOT NULL,
testo = text
);

CREATE TABLE tbl_second (
id INTEGER = DEFAULT nextval('public."tbl_all_ID_seq"'::text) NOT NULL,
= testo text
);

>>> "Daniel "bodom_lx" Graziotin" <daniel.graziotin@gmail.= com> 2007-11-22 12:01 >>>
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 =3D 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

---------------------------(end of broadcast)------------= ---------------
TIP 3: Have you checked our extensive FAQ?

= &nb= sp; http://www.postgresql.or= g/docs/faq

--=__PartC1E7CEC8.0__=--