Re: [GENERAL] unique ID across all columns

2007-04-17 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Felix Kater wrote: >> 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? > Yes, the table OID is unique, and pg_attribute.attn

Re: [GENERAL] unique ID across all columns

2007-04-17 Thread Alvaro Herrera
Felix Kater wrote: > 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

[GENERAL] unique ID across all columns

2007-04-17 Thread Felix Kater
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