Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
unique ID across all columns
- From: Felix Kater <fkater(at)googlemail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: unique ID across all columns
- Date: Tue, 17 Apr 2007 14:48:26 +0200
- Message-id: <20070417144826(dot)c27c9794(dot)fkater(at)googlemail(dot)com>
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
- Follow-Ups:
- Re: unique ID across all columns
- From: Alvaro Herrera
- Re: unique ID across all columns
- Prev by Date: Re: pg_restore "out of memory" - big problem :(
- Next by Date: Re: unique ID across all columns
- Previous by thread: Re: pg_restore "out of memory" - big problem :(
- Next by thread: Re: unique ID across all columns
- Indexes: