Re: Calculated bigserial column in a view

If you want a unique key across several tables, can you not do something
like:

CREATE SEQUENCE detail_seq INCREMENT BY 1;

CREATE TABLE table1 (
table1_id INTEGER PRIMARY KEY DEFAULT nextval('detail_seq'),
item1_name VARCHAR(100) NOT NULL
);

CREATE TABLE table2 (
table2_id INTEGER PRIMARY KEY DEFAULT nextval('detail_seq'),
item2_name VARCHAR(100) NOT NULL
);

Then the union of both tables will contain one unique set of ids.

Assuming that is what you are trying to do, that is.

Susan

----------------------------------------------------------------------------------------------
See our award-winning line of tape and disk-based
backup & recovery solutions at http://www.overlandstorage.com
----------------------------------------------------------------------------------------------