unique ID across all columns - Mailing list pgsql-general

From Felix Kater
Subject unique ID across all columns
Date
Msg-id 20070417144826.c27c9794.fkater@googlemail.com
Whole thread Raw
Responses Re: unique ID across all columns  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Hi,

I need a unique ID across all columns I create. Is it o.k. to
achive this by combining pg_attribute.attnum of a column together with
the OID of the table the column is in?

While the table's OID should be unique according to the manual, I have
found no hints about the uniqueness of attnum -- I removed and added
some columns and it seems that already used values are not used again.

Felix

pgsql-general by date:

Previous
From: Palle Girgensohn
Date:
Subject: Re: pg_restore "out of memory" - big problem :(
Next
From: Alvaro Herrera
Date:
Subject: Re: unique ID across all columns